SQL Installation on Server Core

This is really a note to myself, to remind me what commands I used to installed SQL Server 2016 with Database, Analysis and Integration Services, on a Windows Server 2016 Core server (in a LAB environment of course, hence the super secure passwords :-))

Installation

Setup.exe
/QS
/ACTION=Install
/FEATURES=SQL,AS,IS
/INSTANCENAME=MSSQLSERVER
/SQLSVCACCOUNT=LABS\SQL_SERVICE
/SQLSVCPASSWORD=”Pass@word1″
/AGTSVCACCOUNT=LABS\SQL_AGENT
/AGTSVCPASSWORD=”Pass@word1″
/ASSVCACCOUNT=LABS\SQL_ANALYSIS
/ASSVCPASSWORD=”Pass@word1″
/ISSVCACCOUNT=LABS\SQL_INTEGRATION
/ISSVCPASSWORD=”Pass@word1″
/SQLSYSADMINACCOUNTS=LABS\SQL_ADMINS
/ASSYSADMINACCOUNTS=LABS\SQL_ADMINS
/TCPENABLED=1
/IACCEPTSQLSERVERLICENSETERMS=1
/UPDATEENABLED=True
/SECURITYMODE=SQL
/SAPWD=”Pass@word1″
/SQLTEMPDBDIR=R:\Temp
/SQLUSERDBDIR=S:\Data
/SQLUSERDBLOGDIR=T:\Logs
/SQLBACKUPDIR=U:\Backups
/SQLCOLLATION=”SQL_Latin1_General_CP1_CI_AS”

 

Allow Remote Management

netsh
advfirewall
firewall
add rule
name=SQLPort
dir=in
protocol=tcp
action=allow
localport=1433
remoteip=localsubnet
profile=DOMAIN

Liam Cleary

I work as an Associate Director for Protiviti in Virginia. My main focus is to ensure that SharePoint can either natively or with minimal customization meet the business requirement securely. I am currently a SharePoint MVP focused on Architecture but also cross the boundary into Development and Security. I am often found at user groups, conferences speaking, offering advice, spending time in the community, teaching my kids how to code, raspberry PI programming, hacking the planet and sometimes building Lego robots.

You may also like...