Ms Sql Server 简明教程
MS SQL Server - Services
MS SQL Server 提供以下两项服务，对数据库创建和维护是必需的。还列出了其他用于不同目的的附加服务。
MS SQL Server provides the following two services which is mandatory for databases creation and maintenance. Other add-on services available for different purposes are also listed.
-
SQL Server
-
SQL Server Agent
Other Services
-
SQL Server Browser
-
SQL Server Full Text Search
-
SQL Server Integration Services
-
SQL Server Reporting Services
-
SQL Server Analysis Services
可以使用以下方法获取上述服务。
The above services can be availed using the following method.
Start Services
若要启动其中任何服务，可以使用下列两种方法：
To start any of the services, either of the following two methods can be used.
Method 1 – Services.msc
Step 1 − 转到运行，键入 services.msc 然后单击确定。将出现以下屏幕。
Step 1 − Go to Run, type services.msc and click OK. The following screen appears.
Step 2 − 若要启动服务，右键单击服务，单击启动按钮。服务将启动，如下面快照所示。
Step 2 − To start service, right-click on service, click Start button. Services will start as shown in the following snapshot.
Method 2 – SQL Server Configuration Manager
Step 1 − 使用以下过程打开配置管理器。
Step 1 − Open configuration manager using the following process.
启动 → 所有程序 → MS SQL Server 2012 → 配置工具 → SQL Server 配置管理器。
Start → All Programs → MS SQL Server 2012 → Configuration Tools → SQL Server configuration manager.
Step 2 − 选择服务名称，右键单击，然后单击启动选项。服务将启动，如下面快照所示。
Step 2 − Select the service name, right-click and click on start option. Services will start as shown in the following snapshot.
Stop Services
若要停止其中任何服务，可以使用下列三种方法：
To stop any of the services, either of the following three methods can be used.
Method 1 - Services.msc
Step 1 − 转到运行，键入 services.msc 然后单击确定。将出现以下屏幕。
Step 1 − Go to Run, type services.msc and click OK. The following screen appears.
Step 2 − 若要停止服务，右键单击服务并单击停止。已选择的服务将停止，如下面快照所示。
Step 2 − To stop services, right-click on service and click Stop. The selected service will be stopped as shown in the following snapshot.
Method 2 – SQL Server Configuration Manager
Step 1 − 使用以下过程打开配置管理器。
Step 1 − Open configuration manager using the following process.
启动 → 所有程序 → MS SQL Server 2012 → 配置工具 → SQL Server 配置管理器。
Start → All Programs → MS SQL Server 2012 → Configuration Tools → SQL Server configuration manager.
Step 2 − 选择服务名称，右键单击并单击停止选项。已选择的服务将停止，如下面快照所示。
Step 2 − Select the service name, right-click and click Stop option. The selected service will be stopped as shown in the following snapshot.
Method 3 – SSMS (SQL Server Management Studio)
Step 1 − 连接到实例，如下面快照所示。
Step 1 − Connect to the instance as shown in the following snapshot.
Step 2 − 右键单击实例名称并单击停止选项。将出现以下屏幕。
Step 2 − Right-click on instance name and click Stop option. The following screen appears.
Step 3 − 单击是按钮，将打开以下屏幕。
Step 3 − Click Yes button and the following screen will open.
Step 4 − 在上述屏幕上单击是选项以停止 SQL Server 代理服务。服务将停止，如下面屏幕截图所示。
Step 4 − Click Yes option on the above screen to stop SQL Server agent service. The services will be stopped as shown in the following screenshot.
