SQL Server 2016 CTP2.2 installation configuration method Graphics Tutorial _mssql

SQL Server 2016 CTP2.2 install configuration tutorial

Download an ISO file and extract it (about 2.8G or so), and then double-click the Setup.exe to start the installation.

Install the. NET 3.5 SP1 Before you install and install it in Server Manager-add roles and features

Open the Installation interface

The installation interface has always been familiar, and this installation interface has not changed much since SQL Server2008

Because it is an evaluation version, you do not need a product key to install directly

Check acceptance of License Terms

Verify that the rules are met

Do not tick check update

Select SQL Server Feature Installation

The tall features come up and you can use Polybase to query Hadoop data using standard TSQL

Looks like only see polybase This new feature, other features are SQL Server2012 already have

The first pit in the installation is coming, and if you tick the polybase, it needs to install the Java JRE, because it needs to call the JRE to query the Hadoop data

If you do not check polybase, then only need to download the installation KB2919355 on it

JDK Download Address:

Http://www.oracle.com/technetwork/java/javase/downloads/index.html

Patch KB2919355 Download Address:

support.microsoft.com/en-us/kb/2919355
https://www.microsoft.com/en-us/download/details.aspx?id=42334

or click here to download.

Download interface

Need to download both Clearcompressionflag.exe and windows8.1-kb 2919355-X64.MSU

No check polybase is not required to download and install JRE

You can run SystemInfo in PowerShell before installing this command to inquire if there is a KB2919355 patch installed

Turn on Windows Automatic Updates, let Windows search for the latest patches and install KB2919355

If the KB2919355 patch is OK, and the JRE is installed, the following instance selection interface appears

We can choose the default instance.

Both the SQL service and the SQL Agent service startup account use the Local System account LocalSystem, and the startup type is automatic

Set the password for the SA and add the local Windows user to the SQL Server system administrator

One of the improvements to SQL Server2016 is that you can adjust the number of data files for tempdb based on the number of logical CPUs

That's a really good improvement.

Confirm the configuration is correct, you can click "Install" to install

To install the

At this point, the SQL 2016 installation is complete

Version number

Copy Code code as follows:

SELECT @ @VERSION Microsoft SQL Server 2016 (CTP2.2)-13.0.407.1 (X64) 2015 Copyright (c) Microsoft 21:19:11 ation Enterprise Evaluation Edition (64-bit) on Windows Server R2 Standard 6.3 <X64> (Build 9600:) (Hypervisor )

SQL Server2016 Features List

Features supported by the Editions of SQL Server 2016

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

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.