database:mssql:install_on_server_core

Differences

This shows you the differences between two versions of the page.


—database:mssql:install_on_server_core [2019/10/31 09:04] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== Install MSSQL on Windows Server Core ======
 +<code>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</code>
 +
 +To view the installation wizard on server Core:
 +<code>setup.exe /UIMODE=EnableUIonServerCore</code>
 +
 +Enable Windows Firewall to Allow SQL Server Traffic
 +<code>
 +C:\> netsh advfirewall firewall add rule name="SQL Server 1433" dir=in action=allow 
 +protocol=TCP localport=1433
 +</code>
 +