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
Enter your comment:
136 +1 =
 
  • database/mssql/install_on_server_core.txt
  • Last modified: 2019/10/31 09:04
  • by 127.0.0.1