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=password;database=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?