Automated install and best practices application for Microsoft SQL Server 2016
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
ConfigurationFile.ini
README.md
best_practices_run_once.sql
sql_install.ps1

README.md

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.