Asp .net Web config file connection string with secured

Question

I have following connection string in my web application.

<add name="ApplicationDs" connectionString="Data Source=(localhost);Initial Catalog=DBName;User ID=XXX;Password=xxxxxxx;" providerName="System.Data.SqlClient"/>

For some security purpose , unable to put sql username and password directly in web.config file. If anything build in security option is available in asp .net to handle this.

Advice me

MichaC · Accepted Answer · 2013-09-27 07:27:32Z

2

Use integrated security and run your web application with a user account you gave permissions to within your database.

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

for more connection string examples, find them here http://www.connectionstrings.com/sql-server-2012

answered Sep 27, 2013 at 7:27

MichaC

13.7k2 gold badges49 silver badges57 bronze badges

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

2 Comments

bgs Over a year ago

Thanks.. Hi could you explain about Integrated Security=SSPI

MichaC Over a year ago

stackoverflow.com/questions/1229691/…

Superzadeh · Accepted Answer · 2013-09-27 13:20:47Z

1

You might consider encrypting your connection string section. If the security issue is that the username and password cannot be exposed in clear text, then encryption might help/solve the issue.

For more information on web.config encryption, see this link.

answered Sep 27, 2013 at 13:20

Superzadeh

1,1167 silver badges23 bronze badges

Collectives™ on Stack Overflow

Asp .net Web config file connection string with secured

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related