saga1015 / sql2016_scripted_install

Automated install and best practices application for Microsoft SQL Server 2016

SQL2016_Scripted_Install

This is SQL 2016 scripted install process. There is a best practices script which configures SQL Server with best practices.

A few assumptions here:

--You have SQL Media mounted to the D: drive

--The SSMS silent installer doesn't offer any indication of progress, and has worked about 50% of the time in my testing

--Even though SQL Server 2016 does not require .NET 3.5, Database Mail does. I'm currently waiting to hear back to see if this fixed in CU1

--This looks for updates in C:\SQLUpdates, you may wish to update to a different drive (a network share works well)

--This script puts data files on the E: drive--you may need to change for Azure VMs

--You need to edit the DB Mail settings for your SMTP server.