Is it possible to encrypt the username and password in the connection string in the web.config file (Visual Studio 2015, SQL Server 2014)

Question

So I have a connection string labeled as:

<connectionStrings>
    <add name="TBL_ClassServices" 
         connectionString="Server=(localdb)\MSSQLLocalDB; database=Assignment1; User Id=test; Password=test"
         providerName="System.data.sqlclient" />
</connectionStrings>

I just want to encrypt the User Id and the Password without encrypting the whole connection string itself. Is it possible, and if so, how would you encrypt it, and then decrypt it using aspx.cs (C# back-end) code.

Thanks

to be clear, you couldn't do it inside the connection strings. you could do it in appsettings though. — Eric Lizotte, Jun 06 '17 at 16:40

score 0 · Accepted Answer · answered Jun 06 '17 at 16:38

0

I would suggest using a separate program to set the encrypted string into the config file and decrypt the string in your c# code whenever you need to read the connection string. Here is a helpful post for accomplishing this: Encrypt and decrypt a string

answered Jun 06 '17 at 16:38

Icculus018

1,018
11
19

thanks a lot. helped me a lot – user3574842 Jun 07 '17 at 13:24

Is it possible to encrypt the username and password in the connection string in the web.config file (Visual Studio 2015, SQL Server 2014)

1 Answers1