windows server 2019 一键安装sqlserver2012

准备安装包和脚本

脚本文件说明

文件	说明
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，等待安装完成即可。