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?

Chad Miller · Accepted Answer · 2010-02-02 12:50:23Z

2

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.

answered Feb 2, 2010 at 12:50

Chad Miller

42.4k4 gold badges33 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Varyanica Over a year ago

thank you. i very like the idea of storing connection string in sql table. but my supervisor doesnt like it.

Collectives™ on Stack Overflow

How to secure my connection string? powershell + xml

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related