Installation and configuration methods for SQL Server official edition graphic tutorial, Server2016 installation and configuration

Installation and configuration methods for SQL Server official edition graphic tutorial, Server2016 installation and configuration

Install SQL Server official edition

Today, I finally have time to install the official SQL Server version. It takes a week to download the 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 for server configuration. We recommend that you select this option. Previously, you must set it in the Group Policy Manager, which is much 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.

Specific version

Copy codeThe Code is as follows: select @ versionMicrosoft SQL Server 2016 (RTM)-13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600:) (Hypervisor)

Highlights: SQL Server Installation tutorial Manual

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.