安装SQL Server Express和SQL Server Management Studio-白红宇

安装SQL Server Express和SQL Server Management Studio

阅读量：2532 次

发布时间：2019-05-11

本文共 4544 字，大约阅读时间需要 15 分钟。

SQL server is one of the most used databases in the world. Also, SQL server’s performance is well known to the world. In order to understand any system the best way is to try out the system.

SQL Server是世界上最常用的数据库之一。同样，SQL Server的性能也是举世闻名的。为了了解任何系统，最好的方法是试用该系统。

We will also do the same. Let us install SQL Server into our Windows system.

我们也将这样做。让我们将SQL Server安装到我们的Windows系统中。

安装SQL Server Express (Install SQL Server Express)

Click on the link below to download SQL Server.

The link will take you to the SQL Server download page.

SQL Server Download Options

You will get the above two options for download.

SQL Server下载选项

您将获得以上两个下载选项。

We will be downloading Express edition as that has most of the components that we need to development purpose.
我们将下载Express版本，因为它具有开发所需的大多数组件。

Click on the Download now button. The following file will get downloaded.
单击立即下载按钮。以下文件将被下载。

SQL Server executable file

SQL Server可执行文件

Double click on the downloaded executable file and the following screen will appear.
双击下载的可执行文件，将出现以下屏幕。

SQL Server installation options

SQL Server安装选项

We will select Basic for the purpose of this installation guide as it provides the default configuration options. You can select any one of the three options based on your need. Click on Basic.

对于本安装指南，我们将选择“ 基本” ，因为它提供了默认配置选项。您可以根据需要选择三个选项中的任何一个。单击基本。

SQL server installation license term screen will appear as shown below. Click on Accept.
将显示SQL Server安装许可条款屏幕，如下所示。单击接受。

SQL Server installation license terms

SQL Server安装许可条款

The necessary files will get auto downloaded and the installation process will be in progress.
必要的文件将自动下载，安装过程正在进行中。

SQL Server Installation In Progress

SQL Server安装进行中

Post successful completion of the process. The following screen will appear.
发布成功完成的过程。将出现以下屏幕。

SQL Server Successful installation

SQL Server安装成功

After successful installation, you can click Connect Now to connect to the DB and get started.
成功安装后，您可以单击立即连接以连接到数据库并开始使用。

Now that we have successfully installed SQL Server Express edition. We will need a UI to connect to the DB and run queries.

现在，我们已经成功安装了SQL Server Express版本。我们将需要一个UI来连接到数据库并运行查询。

We will use SQL Server Management Studio for this purpose.

为此，我们将使用SQL Server Management Studio。

安装SQL Server Management Studio (Install SQL Server Management Studio)

SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

SQL Server Management Studio是一个集成环境，用于管理从SQL Server到Azure SQL数据库的任何SQL基础结构。

SSMS provides tools to configure, monitor, and administer instances of SQL. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

SSMS提供了用于配置，监视和管理SQL实例的工具。使用SSMS可以部署，监视和升级应用程序使用的数据层组件，以及构建查询和脚本。

Use SQL Server Management Studio (SSMS) to query, design, and manage your databases and data warehouses.

使用SQL Server Management Studio（SSMS）来查询，设计和管理数据库和数据仓库。

Let us start with the installation of SSMS to understand it better.

让我们从安装SSMS开始，以更好地了解它。

Click on the link below for downloading SQL Server Management Studio
单击下面的链接以下载SQL Server Management Studio

Click on the first link if you are downloading SQL Server Management Studio for the first time and if you already have a 17.x version and want to upgrade to the latest version please click on the second link.
如果您是第一次下载SQL Server Management Studio，并且已经具有17.x版本并想要升级到最新版本，请单击第一个链接。

SQL Server Management Studio Download Link

SQL Server Management Studio下载链接

The following executable file will get downloaded. Double Click on the file.
将下载以下可执行文件。双击文件。

SSMS Setup File

SSMS设置文件

On double-clicking the file. The following screen will appear. Click on Install button.
双击文件。将出现以下屏幕。单击安装按钮。

SSMS Installation Screen

SSMS安装屏幕

After Clicking on Install, the installation procedure will start automatically.
单击安装后，安装过程将自动开始。

SSMS Installation loading package

SSMS安装加载包

Once the installation is complete following screen will appear.
安装完成后，将出现以下屏幕。

SSMS Installation complete

SSMS安装完成

Launch SSMS and Authentication screen will appear. There are various ways to log in. You can select the option based on which you have configured for authentication.
启动SSMS和身份验证屏幕将出现。有多种登录方式。您可以基于配置身份验证来选择选项。