CODEWITHSUNDEEP
xmlpowershellconnection-string
Varyanica
Varyanica

Reputation: 409

How to secure my connection string? powershell + xml

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?

Upvotes: 0

Views: 2231

Answers (1)

Chad Miller
Chad Miller

Reputation: 41757

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.

Upvotes: 2

Related Questions