Eureka Moment Wiki

One eureka moment at the time

User Tools

Site Tools


database:mssql:install_on_server_core

Differences

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

Link to this comparison view

database:mssql:install_on_server_core [2017/08/10 12:59]
database:mssql:install_on_server_core [2019/10/31 09:04] (current)
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>​
 +