Ms Sql Server 简明教程

MS SQL Server - Installation

SQL Server 支持两种类型的安装

SQL Server supports two types of installation −

Standalone
Cluster based

Checks

Check RDP access for the server.
Check OS bit, IP, domain of server.
Check if your account is in admin group to run setup.exe file.
Software location.

Requirements

Which version, edition, SP and hotfix if any.
Service accounts for database engine, agent, SSAS, SSIS, SSRS, if any.
Named instance name if any.
Location for binaries, system, user databases.
Authentication mode.
Collation setting.
List of features.

Pre-requisites for 2005

Setup support files.
.net framework 2.0.
SQL Server native client.

Pre-requisites for 2008&2008R2

Setup support files.
.net framework 3.5 SP1.
SQL Server native client.
Windows installer 4.5/later version.

Pre-requisites for 2012&2014

Setup support files.
.net framework 4.0.
SQL Server native client.
Windows installer 4.5/later version.
Windows PowerShell 2.0.

Installation Steps

Step 1 - 从 https://www.microsoft.com/en-us/evalcenter/download-sql-server-2019 下载评估版

Step 1 − Download the Evaluation Edition from https://www.microsoft.com/en-us/evalcenter/download-sql-server-2019

下载软件后，以下文件会根据您的下载（32 或 64 位）选项而提供。

Once the software is downloaded, the following files will be available based on your download (32 or 64 bit) option.

ENU\x86\SQLFULL_x86_ENU_Core.box

ENU\x86\SQLFULL_x86_ENU_Install.exe

ENU\x86\SQLFULL_x86_ENU_Lang.box

或

ENU\x86\SQLFULL_x64_ENU_Core.box

ENU\x86\SQLFULL_x64_ENU_Install.exe

ENU\x86\SQLFULL_x64_ENU_Lang.box

Note − X86（32 位）和 X64（64 位）

Note − X86 (32 bit) and X64 (64 bit)

Step 2 − 双击“SQLFULL_x86_ENU_Install.exe”或“SQLFULL_x64_ENU_Install.exe”，它将分别在“SQLFULL_x86_ENU”或“SQLFULL_x86_ENU”文件夹中解压安装所需的文件。

Step 2 − Double-click the “SQLFULL_x86_ENU_Install.exe” or “SQLFULL_x64_ENU_Install.exe”, it will extract the required files for installation in the“SQLFULL_x86_ENU” or “SQLFULL_x86_ENU” folder respectively.

Step 3 − 单击“SQLFULL_x86_ENU”或“SQLFULL_x64_ENU_Install.exe”文件夹，并双击“SETUP”应用程序。

Step 3 − Click the “SQLFULL_x86_ENU” or “SQLFULL_x64_ENU_Install.exe” folder and double-click “SETUP” application.

为便于理解，我们在本文中使用的是 SQLFULL_x64_ENU_Install.exe 软件。

For understanding, here we have used SQLFULL_x64_ENU_Install.exe software.

Step 4 − 一旦我们单击“安装”应用程序，将打开以下屏幕。

Step 4 − Once we click on 'setup' application, the following screen will open.

Step 5 − 单击位于上述屏幕左侧的安装。

Step 5 − Click Installation which is on the left side of the above screen.

Step 6 − 单击上述屏幕上右侧显示的第一个选项。将打开以下屏幕。

Step 6 − Click the first option of the right side seen on the above screen. The following screen will open.

Step 7 − 单击确定，然后弹出以下屏幕。

Step 7 − Click OK and the following screen pops up.

Step 8 − 单击下一步以获取以下屏幕。

Step 8 − Click Next to get the following screen.

Step 9 − 务必检查产品密钥选择，然后单击下一步。

Step 9 − Make sure to check the product key selection and click Next.

Step 10 − 选中复选框以接受许可证选项，然后单击下一步。

Step 10 − Select the checkbox to accept the license option and click Next.

Step 11 − 选择 SQL Server 功能安装选项，然后单击下一步。

Step 11 − Select SQL Server feature installation option and click Next.

Step 12 − 选中数据库引擎服务复选框，然后单击下一步。

Step 12 − Select Database engine services checkbox and click Next.

Step 13 − 输入命名的实例（此处我使用 TestInstance），然后单击下一步。

Step 13 − Enter the named instance (here I used TestInstance) and click Next.

Step 14 − 在上述屏幕上单击下一步，随后会出现以下屏幕。

Step 14 − Click Next on the above screen and the following screen appears.

Step 15 − 选择服务帐户名称和上述列出的服务启动类型，然后单击排序规则。

Step 15 − Select service account names and start-up types for the above listed services and click Collation.

Step 16 - 确保选中正确的排序规则选择，然后单击“下一步”。

Step 16 − Make sure the correct collation selection is checked and click Next.

Step 17 - 确保选中身份验证模式选择和管理员，然后单击“数据目录”。

Step 17 − Make sure authentication mode selection and administrators are checked and click Data Directories.

Step 18 - 确保选择上述目录位置，然后单击“下一步”。出现以下屏幕。

Step 18 − Make sure to select the above directory locations and click Next. The following screen appears.

Step 19 - 在上述屏幕上单击“下一步”。

Step 19 − Click Next on the above screen.

Step 20 - 在上述屏幕上单击“下一步”以获取以下屏幕。

Step 20 − Click Next on the above screen to the get the following screen.

Step 21 - 确保正确检查上述选择，然后单击“安装”。

Step 21 − Make sure to check the above selection correctly and click Install.

正如在上述屏幕中所示，安装成功。单击“关闭”完成。

Installation is successful as shown in the above screen. Click Close to finish.