How to install SQL Server 2016
Mount the SQL Server 2016 ISO.
Right-click and select ‘Run as Administrator’.
Select ‘Installation’ on the left pane, and click ‘New SQL Server stand-alone installation or add features to an existing installation’ on the right pane.
While this installation is branded with ‘Evaluation’ edition; you still have the option to choose from 3 different editions.
1. Evaluation Edition
2. Developer Edition
In this example; we are using Developer Edition.
Accept the license terms and click ‘Next’.
Select the feature ‘Database Engine Services’, and ensure you are installing it to the appropriate drive in your server. In this case we are using Drive E: for the purpose of this tutorial.
Provide a name for the ‘Named Instance’.
Here we are using SQL_2016_01, and the ‘Instance ID’ is automatically filled in.
Note: This example uses underscores in the Instance Name. This is not recommended, but this is only a simple walk through.
Provide the SQL Server Service accounts, and ensure the ‘Startup Type’ for the SQL Server Agent is set to ‘Automatic’.
Under the ‘Server Configuration’ tab…
Select ‘Mixed Mode’, and specify a complex password.
Add the following accounts as the ‘SQL Server Administrators’.
Next click on the ‘Data Directories’ tab…
Under the ‘Data Directories’ tab…
In this example we are using the E: drive. However; if at all possible you should always ensure the Data, Log, TempDB, and Backup drives are using segregated drives.
D: – Data
E: – Log
F: – TempDB
G: – Backups
Click the ‘TempDB’ tab.
Add 8 TempDB files, and click ‘Next’.
Be patient as the installation is carried out.
Once the installation completes you may get the following prompt. Keep in mind this does NOT automatically restart the server so you are at liberty to restart it whenever is best.
Click ‘OK’, and ‘Close’.
Categories: Agent Jobs, Alerts, AlwaysOn, Automations, Backup & Restore, Big Data, Cluster, Command Prompt, Configuration, Database Mirroring, ELI5, Error Solutions, Failover, Failover Cluster, Featured, Folder System, Forensics & Auditing, High Availability, How To, Installations, Long Scripts, Management Studio, Mirroring, Notification, Powershell, Quick Fix, Scripts, Security, Short Scripts, SQL Licensing, SQL Stuff, Top, TSQL, Work Arounds