hmcgeehan
asked on
Change web.config to NOT show password when connecting to a SQL Server Database
Hi
I have a web application which connects to a SQL Server database and I use this line in the web.config
<<add key="ConnectionString" value="Server=sppgpo05;UID =intranet; PWD=passwo rd;databas e=myDB;"/>
Now on my database under 'Security \ Logins' I have 'intranet'
This all works fine but I wish to not have the users password in the web.config.
I've setup a domain user 'mydomain\intranet'
so the question is how do I change the line in my web.config?
thanks!
I have a web application which connects to a SQL Server database and I use this line in the web.config
<<add key="ConnectionString" value="Server=sppgpo05;UID
Now on my database under 'Security \ Logins' I have 'intranet'
This all works fine but I wish to not have the users password in the web.config.
I've setup a domain user 'mydomain\intranet'
so the question is how do I change the line in my web.config?
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.