User Tools

Site Tools


database:mssql:install_on_server_core

Install MSSQL on Windows Server Core

Setup.exe /QS /ACTION=Install /FEATURES=SQL,Replication,IS /INSTANCENAME=MSSQL /SQLSVCACCOUNT="NT Authority\System" /SQLSYSADMINACCOUNTS="VK7\Administrator" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SECURITYMODE=SQL /SAPWD="SA_PASSWORD" /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS

To view the installation wizard on server Core:

setup.exe /UIMODE=EnableUIonServerCore

Enable Windows Firewall to Allow SQL Server Traffic

C:\> netsh advfirewall firewall add rule name="SQL Server 1433" dir=in action=allow 
protocol=TCP localport=1433
database/mssql/install_on_server_core.txt · Last modified: 2017/08/10 10:59 (external edit)