SQL Server2016 Official Version installation configuration method graphics and text tutorial _mssql

Install SQL SERVER2016 Official edition

Finally have time to install the SQL SERVER2016 official version today, download the installation package has been used for 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 has been set up in the Group Policy manager before and is a lot easier to use.

The boot board should be a small application installed on your computer when the computer first connects to the server. With the Quick Launch Board, 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

Specific version

Copy Code code as follows:

SELECT @ @versionMicrosoft SQL Server 2016 (RTM)-13.0.1601.5 (X64) APR 2016 23:23:58 Copyright (c) Microsoft Corporati On Enterprise Edition (64-bit) on Windows Server * R2 Datacenter 6.3 <X64> (Build 9600:) (Hypervisor)

Wonderful topic Sharing: SQL Server Installation Tutorial manual

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.