Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server 2016 RC0 Installation and Configuration Changes


By:   |   Read Comments (1)   |   Related Tips: More > SQL Server 2016

Attend a SQL Server Conference for FREE >> click to learn more


Problem

In a previous tip on SQL Server 2016 installation changes, we have seen some changes in the SQL Server 2016 installation process. In this tip we are going to see some additional changes and improvements with the SQL Server 2016 RC0 installation process.

Solution

Microsoft has recently launched SQL Server 2016 Release Candidate 1. Microsoft is getting closer to the production release and in this tip we look at some of the installation changes that were made with SQL Server 2016 RC0.

If we look at the first screen after launching the setup, we can see there is separate line for Install SQL Management Tools. We can see in the description that it will install SQL Server Management Studio, SQL Server command-line utilities, SQL Server PowerShell provider, SQL Server Profiler and the Database Tuning Advisor. In pervious versions this was part of the overall SQL Server install. We will take a look at this a little closer below.

SQL Server 2016 Installation Center

New SQL Server Installation

After starting an installation and when we get to the Feature Selection page, this is what it looks like. We can see all the available features with SQL 2016 including the PolyBase Advance analytics extensions. If we look carefully we do not see the option to select the management tools anymore.

SQL Server 2016 Feature Selection

On the Server Configuration page we can see a new option for enabling Instant File Initialization along with a short description of this feature which enables instant file initialization by avoiding zeroing of data pages. This grants the necessary permissions to the account you picked during setup. Previously to enable this feature we needed to go to security settings | Local security | User rights assignments | Perform Volume Maintenance Tasks and add the SQL Server service account, so now the SQL Server setup does this for us.

SQL Server 2016 Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service

On the Database Engine Configuration page and the TempDB tab, we can set the database size and growth parameters for both database files and the log file.

SQL Server 2016 TempDB Configuration

However there is a restriction where we cannot make the size more than 1024 MB, if we do we will get a validation error as shown below.

SQL Server 2016 TempDB Validation Errors

The remainder of the installation process is the same.

SQL Server 2016 Ready to Install

Install SQL Server Management Tools

Click on Install SQL Server Management Tools from the installation screen and the following screen will launch.

SQL Server 2016 Microsoft SQL Server Management Studio Installation

Click on Install and set up will install the management tools. This will take some time to finish as there are a lot of things being installed. Once setup is finished we are ready to explore SQL Server 2016.

Loading Packages for Microsoft SQL Server Management Studio
Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Rajendra Gupta Rajendra is a Consultant DBA with 9+ years of extensive experience in database administration including large critical OLAP, OLTP, Reporting and SharePoint databases.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Friday, April 08, 2016 - 9:05:16 PM - ASRAT KETEMA Back To Top

Its good to know 


Learn more about SQL Server tools