Eureka Moment Wiki

One eureka moment at the time

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

Discussion

Enter your comment:
U C L W L
 
database/mssql/install_on_server_core.txt · Last modified: 2019/10/31 09:04 (external edit)