VS2019 - Connection Managers not saving passwords

Question

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.

Answer 1

Hi @Jacob Walker ，

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