当前位置:首页 > 知道中心 > SQL Server > 文章

SQL2008无人值守安装

发表于:2013-12-09| 次阅读| 作者:藕码网(原创)
TAG: MSSQL
摘要:详细给出sql2008静默安装的办法

SQL2008现在使用已经越发普遍,可能在某些场合下大家会想静默安装,省去一步一步点击的麻烦。下面就把SQL2008静默安装的方法贴出来,分享给大家。命令如下:

start /wait D:\soft\sql2008\setup.exe /Q /ACTION=Install /CONFIGURATIONFILE="D:\soft\ConfigurationFile.ini" /IACCEPTSQLSERVERLICENSETERMS


ConfigurationFile.ini配置文件信息如下:

;SQLSERVER2008 Configuration File
[SQLSERVER2008]
FEATURES=SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS
ERRORREPORTING=0
PID=GYF3TH2V88GRPPHHWRJPQRTYB
SQMREPORTING=0
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCSTARTUPTYPE=Automatic
ASBACKUPDIR=D:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup
ASCOLLATION=Chinese_PRC_CI_AS
ASCONFIGDIR="D:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config"
ASDATADIR="D:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data"
ASLOGDIR="D:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log"
ASPROVIDERMSOLAP=1
ASSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
ASSVCSTARTUPTYPE=Automatic
ASSYSADMINACCOUNTS=Administrator
ASTEMPDIR="D:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Temp"
BROWSERSVCSTARTUPTYPE=Disabled
INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server"
INSTANCEDIR="D:\Program Files\Microsoft SQL Server"
INSTANCEID=MSSQLSERVER
INSTANCENAME=MSSQLSERVER
SECURITYMODE=SQL
SAPWD=wQ8K#-#*xJiLz
ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
NPENABLED=1
TCPENABLED=1
RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
SQLCOLLATION=Chinese_PRC_CI_AS
SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
SQLSVCSTARTUPTYPE=Automatic
SQLSYSADMINACCOUNTS=Administrator
SQMREPORTING=False
X86=False

具体的参数设置涵义可以参考微软官网,链接:http://technet.microsoft.com/zh-cn/library/ms144259%28v=sql.105%29.aspx


【原创说明】本文属于“藕码网”原创文章,转载请注明来源地址:SQL2008无人值守安装:http://www.oucode.com/zd_mssql/sql2008install.html

  • 用户评论
  • 相关文章
  • 最新评论

    验证码:
  • 暂无关联文章