question

JacobWalker-2765 avatar image
0 Votes"
JacobWalker-2765 asked ZoeHui-MSFT answered

VS2019 - Connection Managers not saving passwords

I have an issue where passwords are not saving in the connection managers in my solution.

I am able to add in the password and test it, then I ok it, however, when I go back in the password has disappeared.

I have done some reading on this and one suggestion I keep coming across is to use a package configuration file.

This seems like much too complex a solution and I'm wondering if it's something far more basic than this.

Other colleagues don't have the issue with the solution and don't have to set up a package configuration file.

Any suggestions on what I can do to rectify will be gratefully received.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @JacobWalker-2765

The designed behavior in SSIS is to prevent storing passwords in a package for safety.

If you couldn't use Windows authentication, the workaround is like you said thatuse a configuration file with the connection string of the connection manager embedded. The password can be stored in the dtsConfig file.

 <Configuration ConfiguredType="Property" Path="\Package.Connections[DBConnection].Properties[ConnectionString]" ValueType="String">
     <ConfiguredValue>Data Source=192.168.45.21;User ID=sqlServerUser; password=myPassword; Initial Catalog=MyDB;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;</ConfiguredValue>
   </Configuration>

More details you may refer:

https://stackoverflow.com/questions/1274080/ssis-connection-manager-not-storing-sql-password

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.