SQL Server 2016 CTP2.2 installation and configuration method graphic tutorial, 2016ctp2. 2

SQL Server 2016 CTP2.2 installation and configuration method graphic tutorial, 2016ctp2. 2

SQL Server 2016 CTP2.2 installation and configuration tutorial

Download an isofile and decompress it (about 2.8gleft and right). In this example, double-click setup.exe to start installation.

Install. NET 3.5 SP1 first, and add roles and functions in Server Manager-to install it.

Open the installation page

The installation interface is as familiar as ever. The installation interface has not changed much since SQL Server2008.

Because it is an evaluation version, you do not need the product key and install it directly.

Select accept license terms

Verify compliance with rules

Do not check for updates

Select SQL Server Function Installation

The advanced function is available. You can use PolyBase to query hadoop data using standard TSQL.

It seems that only the new PolyBase function is available. Other functions are available in SQL Server2012.

The first pitfall occurs during the installation process. If you select PolyBase, java jre needs to be installed because it needs to call JRE to query hadoop data.

If you do not select PolyBase, you only need to download and install KB2919355.

JDK:

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

Patch KB2919355:

Support.microsoft.com/en-us/kb/2919355
Https://www.microsoft.com/en-us/download/details.aspx? Id = 42334

Or click here to download.

Download Page

Download clearcompressionflag.exe and Windows8.1-KB 2919355-X64.msu at the same time

If you do not select PolyBase, you do not need to download and install JRE.

You can run the systeminfo command in powershell to check whether the KB2919355 patch is installed.

Enable Windows automatic update, and enable Windows to search for the latest patch and install KB2919355.

If the KB2919355 patch is correct, the following instance selection page will appear if it is installed with JRE.

Select the default instance.

Both the SQL Service and the SQL proxy service start account use the local system account localsystem. The start type is automatic.

Set the sa password and add a local Windows user as the SQL Server system administrator.

One improvement of SQL Server2016 is that the number of data files in tempdb can be adjusted based on the number of logical CPUs.

This improvement is indeed good.

After confirming that the configuration is correct, you can click "Install" to install

Installed

So far, SQL 2016 has been installed

Version Number

Copy codeThe Code is as follows: SELECT @ VERSION Microsoft SQL Server 2016 (CTP2.2)-13.0.407.1 (X64) Jul 22 2015 21:19:11 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600:) (Hypervisor)

SQL Server2016 function list

Features Supported by the Editions of SQL Server 2016

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

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.