Shulou(Shulou.com)06/01 Report--

The official version of Microsoft database SQL Server 2016 was released in June 2016. due to the recent busy work, I have not had time to write the installation process on my blog and share it with you. I have been used to using the English version, so the version and screenshots are in English. Cut the crap and get down to business.

Download address: https://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/ or http://msdn.itellyou.cn/

Download address of the development version: https://myprodscussu1.app.vssubscriptions.visualstudio.com/downloads

KB2919442 download address: https://www.microsoft.com/en-us/download/details.aspx?id=42162

KB2919355 download address: https://www.microsoft.com/en-us/download/details.aspx?id=42335

KB3164398 download address: https://www.microsoft.com/en-us/download/details.aspx?id=52687

SSMS download address: https://msdn.microsoft.com/en-us/library/mt238290.aspx

JRE download address: http://java.com/en/

Official document: https://msdn.microsoft.com/en-us/library/ms130214.aspx

Hardware and software requirements: https://msdn.microsoft.com/en-us/library/ms143506.aspx

Environment: Windows Server 2012 R2 DataCenter

SQL version: 64-bit English corporate copyright

Figure-1: official page of SQL Server 2016

The installation process also experienced several twists and turns and was not very smooth. But in the end, the installation was successful. The problems encountered are explained in the specific steps of the installation. If you need to refer to the installation of children's shoes, you can browse through them before you start the installation.

Figure-2: open the SQLServer2016-x64-ENU installation package

Figure-3

Figure-4

Figure-5

Figure-6

Figure-7

Figure-8

Figure-9

Figure-10

Figure-11

Two errors were encountered during validation, as shown below. Originally thought that like the RC0 version (SQL 2016 RC0 installation process, please refer to: http://www.cnblogs.com/fishparadise/p/5288594.html), install JER7 and KB2919355 on it, but encountered the problem of unsuccessful installation of KB2919355.

Figure-12: KB2919355 installation error

Error installing KB2919355. Later, after reading the instructions of KB2919355 in detail, I found that you should install KB2919442 first and then install KB2919355, and the KB2919355 download page also contains several other patches, which must also be installed in the order of the installation instructions, as detailed in the instructions of KB2919355. The strange thing is that the system requirement specified by KB2919355 is Windows 8.1. after looking for it for a long time, there is no Windows Server 2012 version of KB2919355.

Figure-13

Figure-14: installation instructions for KB2919355

After the patch has been successfully installed, continue.

Figure-15

Since I already have a default instance on my machine, I can only use named instances.

Figure-16

Figure-17

Figure-18

Figure-19

Figure-20

Figure-21

Figure-22

Figure-23

Figure-24

Figure-25

Figure-26

Figure-27

Figure-28

Figure-29

Figure-30

Figure-31

Figure-32

The official version does not have the default installation of SSMS. You need to click on the interface of the installer (see Figure-4). Clicking Install SQL Server Management Tools will automatically open the following address, select your desired language version and download and install it.

Figure-33

Figure-34

Figure-35

Figure-36

Figure-37

Figure-38

Microsoft SQL Server 2016 (RTM)-13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows Server 2012 R2 Datacenter 2012 (Build 9600:) (Hypervisor)

Figure-39

Figure-40

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.