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 began my career as a Trainer of all things computer related. However, I very quickly realized that programming, breaking, and hacking was a lot more fun. I then spent the next few years working on core infrastructure and security services, until I found SharePoint. I am now the founder and owner of SharePlicity, a consulting company that focuses on all areas of Technology. My role within SharePlicity is to help organizations implement technology that will enhance internal and external collaboration, document and records management, automate business processes and of course security controls and protection. I am also an eleven-time Microsoft MVP focusing on Architecture but also cross the boundary into Development. My specialty over the past few years has been security in SharePoint and its surrounding platforms. I can also be found at user groups or conferences speaking, offering advice, spending time in the community, teaching my kids how to code, raspberry PI programming, hacking the planet or building Lego robots.

You may also like...