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