How to secure my connection string? powershell + xml

Question

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?

Answer 1

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.