SQL Server2016 Official Edition installer Illustrated tutorial _mssql

Finally have a weekend, not idle, take advantage of this time to install the SQL server2016 official version, download the installation package has been spent one weeks

Installation packages can be downloaded from here: http://www.itellyou.cn/

Https://msdn.microsoft.com/zh-cn/subscriptions/downloads/hh442898.aspx

Installation Environment

Hyper-V virtual machines

WINDOWS2012R2 Data Center Edition

Open the installation package to see now that the SQL engine features and SSMS have been installed separately

Supports only 64-bit

Feature selection of the more out of R server, but the R server needs to be networked or downloaded, this is one of the pit dad's place, it is not integrated in the SQL SERVER2016 installation package

Server Configuration The "Perform Volume maintenance task" privilege is added here, and it is recommended to check that it was previously set in the Group Policy manager to facilitate a number of

The boot board should be a small application installed on your computer when the computer first connects to the server. With the Quick Launch pad, Authenticated users have access to the main features of SQL Server

Another improvement is that the tempdb settings are more humane and offer many options

As mentioned earlier, R server needs to be downloaded online or downloaded separately

To start the installation, SQL Server2016 needs to be up to date. NET4.6

I see from the computer time, installation time from 11:35 to 11:48, about 13 minutes

SQL Service after installation

After installation, do not forget to install SSMS, this is the place of the pit dad Two, why not integrated into the SQL Server installation package and users themselves to download

Download Address: https://msdn.microsoft.com/en-us/library/mt238290.aspx?f=255&MSPPError=-2147217396

Since SSMs is a standalone shell based on VS2015, the installation interface is almost the same as VS's installation interface

The above is a small series to introduce the SQL SERVER2016 official version of the installation program illustrated tutorial, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!