Some changes in SQL Server 2016 Setup

Today I’ve installed SQL Server 2016 on a Windows Server 2012 R2 machine. Some things are changed  compared to the SQL 2014, SQL2012 and SQL 2008 R2 setups. A few changes:

1. You don’t need to install the .NET Framework 3.5 prerequisite anymore. Instead it installs the .NET Framework 4.6 automatically if it isn’t installed yet. In previous setups (SQL 2014, SQL 2012 and SQL 2008 R2) you first needed to install the .NET Framework 3.5 manually.
2. During setup it’s now possible to Grant the ‘Perform Volume Maintenance Task’ permission to the SQL Server database engine:

Grant Volume Maintenance Task privilege during SQL 2016 Setup

3. On the database engine configuration you now have the option to configure the tempdb data- en logfile:

TempDB Settings during SQL 2016 Setup

4. Installing the ‘SQL Server Management Studio’ isn’t an installation option anymore. If you want to install it you must download it from Microsoft manually. Download SQL Server 2016 Management Studio.

SQL Server Management Studio 2016



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s