sqlserver2008静默安装的bat脚本

大家好：

    下面是sqlserver2008静默安装的bat脚本，将如下的脚本复制到bat文件中执行即可。

       echo Error:Not Correct Install File For SQLServer 2008

       pause

       exit

)

echo "Start Install SQLServer2008..."

if defined SQLCOLLATION (

%SourcePath%\setup.exe /q /ACTION=Install ^

/FEATURES=SQL,Tools ^

/SQLCOLLATION="%SQLCOLLATION%" ^

/INSTANCENAME=MSSQLSERVER ^

/PID="XXXXXXXXXXXXXXX" ^

/SQLSVCACCOUNT="NTAUTHORITY\SYSTEM"  ^

/SQLSYSADMINACCOUNTS=".\Administrator"^

/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" ^

/SECURITYMODE="SQL" ^

/SAPWD="XXXXXXXXXXXXXXXX" ^

/AGTSVCSTARTUPTYPE="Automatic" ^

/SQLSVCSTARTUPTYPE="Automatic" ^

/TCPENABLED="1" ^

/NPENABLED="0" ^

/SQLTEMPDBDIR="D:\ms_data" ^

/SQLTEMPDBLOGDIR="D:\ms_log" ^

/SQLBACKUPDIR="D:\ms_backup" ^

/SQLUSERDBDIR="D:\ms_data" ^

/SQLUSERDBLOGDIR="D:\ms_log" ^

/IACCEPTSQLSERVERLICENSETERMS

)

if not defined SQLCOLLATION (

%SourcePath%\setup.exe /q /ACTION=Install ^

/FEATURES=SQL,Tools ^

/INSTANCENAME=MSSQLSERVER ^

/PID="XXXXXXXXXXXX" ^

/SQLSVCACCOUNT="NTAUTHORITY\SYSTEM"  ^

/SQLSYSADMINACCOUNTS=".\Administrator"^

/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" ^

/SECURITYMODE="SQL" ^

/SAPWD="XXXXXXXXXXXXXXXXXXX " ^

/AGTSVCSTARTUPTYPE="Automatic" ^

/SQLSVCSTARTUPTYPE="Automatic" ^

/TCPENABLED="1" ^

/NPENABLED="0" ^

/SQLTEMPDBDIR="D:\ms_data" ^

/SQLTEMPDBLOGDIR="D:\ms_log" ^

/SQLBACKUPDIR="D:\ms_backup" ^

/SQLUSERDBDIR="D:\ms_data" ^

/SQLUSERDBLOGDIR="D:\ms_log" ^

/IACCEPTSQLSERVERLICENSETERMS

)

echo "Finished Install SQLServer 2008"

set PATH=%PATH%;C:\Program Files\MicrosoftSQL Server\100\Tools\binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;

echo "Disable user sa,and createmonitor user XXX"

rem 禁用sa用户

sqlcmd -d "master" -Q"ALTER LOGIN [sa] DISABLE;select‘sqlserver init OK‘"

echo "Finished user setting"

pause

Exit

本文出自 “” 博客，请务必保留此出处