ASP.Net Code: Connection Strings with MS SQL server 2005

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'

ASP.NET Code: Microsoft SQL Server Tutorial

ASP.NET Code: Microsoft SQL Server Tutorial

http://www.functionx.com/sqlserver/Lesson02.htm