工作日誌: load DB, Asp.net 入 MS SQL 2005 Server

工作日誌: load DB, Asp.net 入 MS SQL 2005 Server

1. load SQL 入 MS SQL 2005 Server
2. set 唔到 Connection Strings
3. 唯有安Visual Web Developer 2008 Express
4. 都係 set 唔到 Connection Strings
跟 http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
得左

Connection Strings 要 set LocalSqlServer
先見到 ASP.NET config

5. Asp.net 個web 係VWD ok, 出到 IIS 唔得
6. MS SQL 2005 Server access right problem
Connection Strings 無password

原來要係SSMS

exec sp_grantloginaccess 'NT AUTHORITY\NETWORK SERVICE'
exce sp_addsrvrolemember @loginame = 'NT AUTHORITY\NETWORK SERVICE', @rolename = 'sysadmin'

中文
http://www.cnblogs.com/windphoenix/archive/2008/11/03/1325321.html
英文
http://forums.asp.net/p/905865/1836699.aspx
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/26fd5295-e9e2-44e7-9a3d-6af69da77093/
http://stackoverflow.com/questions/764494/no-admin-rights-in-sql-management-studio

7. web ok la...
8. Asp.net 個網 access right problem
set 番 IIS 個right -> 唔得
set 番 folder 個right -> 終於得

set 完個頭出晒煙