工作日誌: 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 完個頭出晒煙

ASP.NET Step: Move / Export Database from Microsoft SQL Server 2008 to mdf File

ASP.NET Step: Move / Export Database from Microsoft SQL Server 2008 to mdf File

1. Download SQL Server Management Studio
from VWD website

2. Read the followings doc
http://www.windows-tech.info/15/206f0457374acafb.php

3. Follow Steps in
How to: Detach a Database (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms191491.aspx

4. Copy the mdf to VWD website's App_Data Folder
from
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

5. Open Web.config
Replace the connection String as we detached the database from server
and run it as standalone file

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />