Installing SQL Server 2017

Microsoft's SQL Server version, in addition to many very quickly, from the earliest version to the current SQL Server 2017, each iteration of the version has updated a lot of features and enhanced stability, security, and so on, but starting with SQL Server 2016, only 64-bit version, and began to support the R language, to SQL Server 2017, not only support the R language also support Python, of course, there are now popular mechanical learning and so on. Today I'll tell you about the installation of SQL Server 2017.

Here, I have prepared a Windows Server R2 system, first need to install SQL 2017 required server roles and features

. Net Framework 3.5

Role services for IIS

Start installation

Next put the installation CD for SQL 2017, before installing SQL Server 2017, we need to install the Java JRE Program, recommended 7 and 51 (64) or later

Installation Complete

Then you can start installing SQL 2017

Run the installation prerequisite check

Here you see Reporting Services for Microsoft SQL Server 2017 need to download the installation separately

https://www.microsoft.com/zh-cn/download/details.aspx?id=55252

Here, I don't care. Reporting Services, all features selected, next

The feature rule checks to see if the installation requirements are met, and if you do not install JRE 7 update 51 (64) or later, the following check fails to appear, you can go to the Oracle website to download

Http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase7-521261.html

Default instance, next

Next

Next

Set the sa password and the current administrator for SQL administrator

Add Administrator as Analysis service administrator

Scale-out for Integration services default, Next

Next

Distributed Replay Controller Add Administrator as Administrator, next

Next

Accept the consent download install Microsoft R Open

Next

Accept consent Download Install Python

Next

If you do not have access to the Internet in your environment, then you need to download the R and Python components required for machine learning in advance, and you can download the corresponding components based on your version of SQL in the following Web site

https://docs.microsoft.com/zh-cn/sql/advanced-analytics/install/ sql-ml-component-install-without-internet-access?view=sql-server-2017

When downloading under the site, you need to note that the default download is the end of 1033.cab (1033 is the English version), but the actual 1033 is to be based on your SQL language version environment to download these files to use after renaming

Specific what language version corresponds to what number can refer to https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/ sys-syslanguages-transact-sql?view=sql-server-2017

NOTE: When installing SQL Server SP1 CU4 or SP1 CU5 offline, download sro_3.2.2.16000_1033.cab. Installing SQL Server S P1 CU4 or SP1 CU5 offline, download Sro_3.2.2.16000_1033.cab. If you can download Sro_3.2.2.13000_1033.cab from Fwlink 831785, as shown in the Setup dialog box, rename the file before you install the cumulative update as Sro_3.2.2.16000_1033.cab.

1033 is English, 2052 is Chinese, so here I need to rename these files to 2052

Select the directory where the downloaded components are located, next

Click Install

Wait for the installation to complete and will prompt for restart

After installation, you can download SQL Server Management Studio (SSMS) to connect to the following connection, install using connect SQL Server 2017

https://docs.microsoft.com/zh-cn/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Install it and connect to login later.

Here my SQL Server main body is installed, this is introduced today, in fact, this installation of SQL Server 2017 is to introduce you to install the Powerbi Report Server (local) to prepare.

Installing SQL Server 2017