I store my connection-string in XML file. Then i use it in powershell script. Is there a way to secure it/to encrypt it somehow?
How to secure my connection string? powershell + xml
There are two methods I've seen for encrypting in Powershell
Use *SecureString cmdlets. It should be noted only the Windows ID that encrypted the original string can decrypt it (since it uses the Windows login as key)
Use a pass phrase with the Library-StringCrypto functions
Because of the limitations of the first method, I use the second. I'll then store my encrypted connection string in a SQL table and lock down permissions. To make a connection I'll retrieve the connection string from the SQL table and decrypt using a pass phrase.