SQL server2016 Setup Diagram

today finally has time to install SQL Server2016 full version, download that installation package took one weeks

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 machines

WINDOWS2012R2 Data Center Edition

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

only 64-bit support

more features in the selection . R server, but R server needs to be networked or downloaded on its own, which is one of the places where the pit daddy is not integrated in the SQL SERVER2016 installation package

server Configuration This adds the "Perform volume maintenance tasks" privilege, which is recommended to be set in the Group Policy manager, which facilitates a lot of

The launchpad should be a small application installed on the computer when the computer first connects to the server. With the launchpad, Authenticated users can access the main features of SQL Server

Another improvement is The tempdb settings are more user-friendly and offer many options

as mentioned earlier, R server requires a networked download or a separate download

start the installation, SQL Server2016 requires the latest. NET4.6

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

after the installation is done SQL Service

don't forget to install when you're done. SSMS, this is the place of the pit daddy. Not integrated into the SQL Server installation package also needs to be downloaded separately by the user

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

because SSMs is a standalone shell based on VS2015, so the installation interface is almost identical to the installation interface of VS

Specific version

SQL server2016 Setup Diagram