准备安装包和脚本
脚本文件说明
文件 | 说明 |
install.bat | sqlserver 2012 安装主脚本,调用了sql_server_2012_slient目录中的install_sql_server.bat脚本 |
install.ps1 | 安装netframe3.5 |
*.cab | netframe3.5离线安装包 |
脚本代码
install.bat:其中调用了另外的一个脚本
REM 自动判断权限问题,主动获取管理员权限
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"
if '%errorlevel%' NEQ '0' (
goto UACPrompt
) else ( goto gotAdmin )
:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"
"%temp%\getadmin.vbs"
exit /B
:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
pushd "%CD%"
CD /D "%~dp0"
:begin
@REM 安装netframework3.5
start powershell .\install.ps1
@REM 安装sqlserver
cd sql_server_2012_slient
cmd /c install_sql_server.bat
install_sql_server.bat:在sql_server_2012_slient文件夹中
@REM 创建安装目录
md "%~d0\Program Files\Microsoft SQL Server"
md "%~d0\Program Files (x86)\Microsoft SQL Server"
md "%~d0\Program Files (x86)\Microsoft SQL Server\DReplayClient\ResultDir"
md "%~d0\Program Files (x86)\Microsoft SQL Server\DReplayClient\WorkingDir"
md "%~d0\Program Files\Microsoft SQL Server"
md "%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data"
md "%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log"
md "%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Backup"
md "%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Temp"
md "%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config"
@REM 关闭防火墙
netsh advfirewall set allprofiles state off
@REM 打开防火墙
@REM netsh advfirewall set allprofiles state on
@REM cd shell
@REM sed -i '55d' ..\ConfigurationFile.ini
@REM sed -i '54a\INSTALLSHAREDDIR="%~dp0Microsoft SQL Server"' ..\ConfigurationFile.ini
@REM cd ..
@REM 安装
.\setup.exe /SAPWD="Tuners2012" /ASSYSADMINACCOUNTS="%computername%\%username%" /SQLSYSADMINACCOUNTS="%computername%\%username%" /INSTALLSHAREDDIR="%~d0\Program Files\Microsoft SQL Server" /INSTALLSHAREDWOWDIR="%~d0\Program Files (x86)\Microsoft SQL Server" /CLTRESULTDIR="%~d0\Program Files (x86)\Microsoft SQL Server\DReplayClient\ResultDir" /CLTWORKINGDIR="%~d0\Program Files (x86)\Microsoft SQL Server\DReplayClient\WorkingDir" /INSTANCEDIR="%~d0\Program Files\Microsoft SQL Server" /ASDATADIR="%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data" /ASLOGDIR="%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log" /ASBACKUPDIR="%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Backup" /ASTEMPDIR="%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Temp" /ASCONFIGDIR="%~d0\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" /CONFIGURATIONFILE="%CD%\ConfigurationFile.ini"
install.ps1
Install-WindowsFeature Net-Framework-Core -source (Get-Location).path
安装
双击install.bat,等待安装完成即可。