How to stop and start MsSqlServer

After MsSqlServer2005 is installed, I am not used to it. Since I have been using sqlserver2000 before, I found that sqlserver2005 has been changed in many places. Sometimes it takes a long time to find a small function. This is not the first time to stop the sqlserver2005 service to reduce memory overhead because of the need for other processing work,

After installing Ms SQL Server 2005, I am not used to it. Because I have been using SQL server 2000 before, I found that SQL server 2005 has been changed in many places, and sometimes a small function is required for a long time. This is not the first time to stop the SQL server 2005 service to reduce memory overhead because of the need for other processing work,

After installing Ms SQL Server 2005, I am not used to it. Because I have been using SQL server 2000 before, I found that SQL server 2005 has been changed in many places, and sometimes a small function is required for a long time. Today, because I need to do other processing work, I disabled the SQL server 2005 service to reduce memory overhead. This is not the first time I did this. I generally did this through SQL Server Management Studio. After the service was stopped, SQL Server Management was not launched directly. Therefore, you can simply restart the service when necessary.

To minimize the memory size, all irrelevant windows are closed. After that, you need to re-enable the SQL server service to find that you can no longer access SQL Server Management. Haha, so I searched the internet and found that there are several ways to enable and disable the Ms SQL Server.

1. Start Menu-> RUN

-- Start the SQL server 2005 service

Net start mssqlserver

-- Stop the SQL server 2005 service

Net stop mssqlserver

2. Choose Start> program> Microsoft SQL Server 2005> Configuration tool.

SQL Server Configuration Manager-> SQL Server (MSSQLSERVER) Right-click to start the service, and the status is displayed as "running"

3. Choose Start> RUN> services. msc service console.

After you right-click SQL Server (MSSQLSERVER) and choose "started" from the shortcut menu, the status is displayed as "started"

Note: What about port 1433?

When installing SQL SERVER 2005, TCP/IP and port 1433 are not enabled by default.

-> SQL Native Client configuration-> enable TCP/IP and port 1433 under the Client protocol.

All right, these methods should be sufficient for starting and stopping Ms SQL Server.

,