SQL SERVER2005 自动安装


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

参考:http://technet.microsoft.com/zh-cn/library/ms144259(SQL.90).aspx
运行:start /wait setup.exe /qb /settings setup.ini (注:setup.exe最好是SQL Server x86\Servers下的)
start /wait :dos命令,启动应用程序并等待它结束。
setup.ini可参考\SQL Server x86\Servers下的template.ini文件
注:其中的/qb表示可看见安装画面,若改为/qn则完全在后台运行安装
setup.ini配置:
[Options]
USERNAME=user
COMPANYNAME=lvshou
PIDKEY=B4H74BJX3P37RX2J9TTBH9RMJ
INSTALLSQLDIR=”C:\Program Files\Microsoft SQL Server\”
INSTALLOLAPDATADIR=”C:\Program Files\Microsoft SQL Server\MSSQL\OLAP\Data”
ADDLOCAL=All
INSTANCENAME=MSSQLSERVER
SECURITYMODE=SQL
SAPWD=LifeIsGood
SQLACCOUNT=NT AUTHORITY\SYSTEM
AGTACCOUNT=NT AUTHORITY\SYSTEM
SQLBROWSERACCOUNT=NT AUTHORITY\SYSTEM
ASACCOUNT=NT AUTHORITY\SYSTEM
RSACCOUNT=NT AUTHORITY\SYSTEM
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=1

注:INSTALLOLAPDATADIR,数据库文件(如.mdf和.ldf)的默认存放目录
ASACCOUNT:Analysis Services
RSACCOUNT:Reprot Services
SQLBROWSERAUTOSTART=1 1为自动启动,0为手动启动。
SQLAUTOSTART=1
AGTAUTOSTART=1
SECURITYMODE=SQL :身份验证模式,当为sql时表示混合验证,若未指定,则是windows验证

SQLServer2005SP3-KB955706-x86-CHS.exe /quiet /allinstances