IT security people are asking me to not have unencrypted username/passwords on disk any longer. But I use several DSN files and need to be able to indicate what connection string to use. Is there a way to connect to a SQL database using the .NET encrypted version of a connection string? Or are there other means to handle this?
I have connections strings such as:
Provider=SQLOLEDB.1;Data Source=MYSERVER;Initial Catalog=MYDATABASE;User Id=MYUSERID;Password=MYPASSWORD