After a quick search i found this on Microsoft Support. That happens because:
The Allow saving password check box was not selected on the Connection tab of the Data Link Properties dialog box, when the connection to the data source was made.
CaldeiraG
Posted 2018-04-06T15:02:39.633
Reputation: 2 504
I’m not sure what you quote from the link is relevant to OP’s question. -1 – Ultrasonic54321 – 2018-04-06T16:05:42.493
I’m not sure what you quote from the link is relevant to OP’s question. -1 – Ultrasonic54321 – 2018-04-06T16:05:42.493