Graphic tutorial of the official installation program of SQL Server2016, sqlserver2016

Graphic tutorial of the official installation program of SQL Server2016, sqlserver2016

It's hard to have a weekend and you can't be idle. It takes a week to install the official SQL Server Installation Package.

The installation package can be downloaded from here: http://www.itellyou.cn/

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

Installation environment

Hyper-v Virtual Machine

Windows2012R2 data center Edition

Open the installation package and you can see that the SQL engine function and SSMS have been installed independently.

Only 64-bit

The R Server exists in the function selection, but the R Server needs to be connected or downloaded by itself. This is one of the pitfalls. It is not integrated into the SQL Server2016 installation package.

The "execute volume maintenance task" privilege is added here for server configuration. It is recommended that you select this option. Previously, you must set it in the Group Policy Manager to make it easier.

The boot board should be a small application installed on the computer when the computer first connects to the server. With the Quick Start board, authenticated users can access the main functions of SQL Server

Another improvement is that the settings of Tempdb are more user-friendly and provide many options.

As described above, the R Server needs to be downloaded online or independently.

Start installation. SQL Server2016 requires the latest. NET4.6

According to my computer time, it took about 13 minutes to install it from.

SQL service after installation

After the installation, do not forget to install SSMS. This is the second part of the pitfalls. Why not integrate SSMS into the SQL Server Installation Package and download it by yourself?

: Https://msdn.microsoft.com/en-us/library/mt238290.aspx? F = 255 & MSPPError =-2147217396

Because SSMS is an independent shell Based on VS2015, the installation interface is almost the same as that of.

The above is a graphic tutorial of the SQL Server2016 official version of the installation program. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!