QUICKSTART2.0&SQLSERVER2005配置说明

先决条件：操作系统 windows server 2003 ,已安装VISUAL STUDIO 2005(未选择SQL SERVER EXPRESS的安装) 和 SQL SERVER 2005

1.打开2.0的"快速入门"页面，点击"安装快速入门"

2.选择"不安装SQL SERVER EXPRESS"

3.在命令提示符下进入"SDK/v2.0/samples/setup"文件夹，然后运行下列命令:

sqlcmd -E -S (local) -i InstPubs.sql
sqlcmd -E -S (local) -i InstNwnd.sql
sqlcmd -E -S (local) -i InstGrocer.sql
sqlcmd -E -S (local) -i InstContacts.sql
sqlcmd -E -S (local) -i InstPhotos.sql
sqlcmd -E -S (local) -i Inst_FileSystemSQL.sql

4.在“WINDOWS/Microsoft.NET/Framework/v2.0.50727”文件夹下，运行以下命令，生成"aspnetdb"数据库：

aspnet_regsql.exe -S (local) -E -A all

5.运行以下命令：
sqlcmd -E -S (local) -Q "sp_grantlogin 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d Pubs -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d Pubs -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d NorthWind -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d NorthWind -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d GrocerToGo -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d GrocerToGo -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d Contacts -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d Contacts -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d Photos -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d Photos -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d FileSystemSQL -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d FileSystemSQL -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d ASPNETDB -Q "sp_grantdbaccess 'NT AUTHORITY/NETWORK SERVICE'"
sqlcmd -E -S (local) -d ASPNETDB -Q "sp_addrolemember 'db_owner', 'NT AUTHORITY/NETWORK SERVICE'"

6.将“Program Files/Microsoft Visual Studio 8/SDK/v2.0/QuickStart”文件夹下所有文件中的“/SQLExpress”替换为空。

7.OK。大功告成。