Microsoft SQL Server is provided with different licenses. Free version is named Express Edition
. Express Edition is very useful if we need a little database.
Microsoft SQL Server提供了不同的许可证。 免费版名为Express Edition
。 如果我们需要一些数据库,则Express Edition非常有用。
下载 (Download)
We will download the SQL Server 2017 Express Edition from following link which is provided by Microsoft.
我们将通过Microsoft提供的以下链接下载SQL Server 2017 Express Edition。
https://www.microsoft.com/en-us/sql-server/sql-server-editions-express
https://www.microsoft.com/zh-cn/sql-server/sql-server-editions-express

开始安装(Start Installation)
We will download a simple install starter executable which is name SQLServer2017...
. This will start the process and do not provide all packages which will be install. All packages installed from internet.
我们将下载一个简单的安装启动程序可执行文件,名为SQLServer2017...
这将开始该过程,并且不会提供将要安装的所有软件包。 从互联网安装的所有软件包。

选择SQL Server 2017安装类型(Select SQL Server 2017 Installation Type)
There are different installation type. We can use following installation types.
有不同的安装类型。 我们可以使用以下安装类型。
- `Basic` type will install default packages by downloading from internet. In this tutorial we will use this installation type. `Basic`类型将通过从Internet下载来安装默认软件包。 在本教程中,我们将使用这种安装类型。
- `Custom` type provides customization features where we can install extra features of MS SQL or remote some default features. “自定义”类型提供自定义功能,我们可以在其中安装MS SQL的其他功能或远程一些默认功能。
- `Download Media` type will only download from internet and do not start installation. This can be useful if we do not have an internet connection and install MS SQL. “下载媒体”类型将仅从Internet下载,并且不会开始安装。 如果我们没有互联网连接并安装MS SQL,这将很有用。

接受许可条款(Accept License Terms)
As usual the Microsoft SQL Server license.
与往常一样,Microsoft SQL Server许可证。

下载安装包(Download Install Package)
Installation packages will be downloaded from internet to the local. After download is complete we do not need internet anymore.
安装包将从互联网上下载到本地。 下载完成后,我们不再需要互联网。

安装阶段(Installation Phase)
After the installation packages are downloaded to the local from internet we will continue with the installation of the SQL Server packages.
从Internet将安装包下载到本地后,我们将继续安装SQL Server包。

设定设定(Setup Configuration)
Installation has complete successfully. After installation screen we will see some configuration options which can be used in further usage. We will get following information.
安装已成功完成。 安装屏幕后,我们将看到一些配置选项,可用于进一步使用。 我们将获得以下信息。
- `Instance Name` will display database server instance name. “实例名称”将显示数据库服务器实例名称。
- `SQL Administrators` will display users who is Administrator for installed SQL Server. “ SQL Administrators”将显示已安装SQL Server管理员的用户。
- `Features Installed` will display installed features. “已安装的功能”将显示已安装的功能。
- `Version` will display installed SQL Server Express Version. “版本”将显示已安装SQL Server Express版本。

列出MS SQL Server Express服务状态(List MS SQL Server Express Service Status)
There is different ways to list SQL Server Express status. In this case we will Powershell. We will use Get-Service
commandlet to list MS Sql Service status.
有多种列出SQL Server Express状态的方法。 在这种情况下,我们将使用Powershell。 我们将使用Get-Service
命令行开关列出MS Sql Service状态。
PS> Get-Service 'MSSQL$SQLEXPRESS'

启动MS SQL Server Express服务(Start MS SQL Server Express Service)
We will use following commandlet to start MS SQL Server Express edition with the Get-Service
.
我们将使用以下Commandlet通过Get-Service
启动MS SQL Server Express版本。
PS> Start-Service 'MSSQL$SQLEXPRESS'
停止MS SQL Server Express服务 (Stop MS SQL Server Express Service)
We will use Stop-Service
powershell command in order to stop MS SQL Server Express.
我们将使用Stop-Service
powershell命令来停止MS SQL Server Express。
PS> Stop-Service 'MSSQL$SQLEXPRESS'
翻译自: https://www.poftut.com/how-to-download-and-install-ms-sql-server-2017-express-on-windows/