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

Next revision
Previous revision
database:mssql:install_on_server_core [2017/04/10 20:57]
tplecko created
database:mssql:install_on_server_core [2017/08/10 12:59] (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>​
 +
  
database/mssql/install_on_server_core.txt · Last modified: 2017/08/10 12:59 (external edit)