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'
2009年8月26日星期三
訂閱:
發佈留言 (Atom)
沒有留言:
發佈留言