ASP.Net Code: Connection Strings with MS SQL server 2005
<remove name="LocalSqlServer">
<add name="LocalSqlServer" connectionstring="Data Source=localhost;Initial Catalog=aspnetdb;Integrated Security=True" providername="System.Data.SqlClient">
<add name="golddbConnectionString" connectionstring="Data Source=localhost;Initial Catalog=golddb;Integrated Security=True" providername="System.Data.SqlClient">
+
exec sp_grantloginaccess 'NT AUTHORITY\NETWORK SERVICE'exce sp_addsrvrolemember @loginame = 'NT AUTHORITY\NETWORK SERVICE', @rolename = 'sysadmin'