How Ms SQL Server stops and starts

After installing MS SQL Server 2005, it's not a good habit. Because you've been using SQL Server 2000 before, you've found that SQL Server 2005 has been changed in many places, sometimes with a little bit of functionality. It's not the first time I've done this today because I need to do other processing work to deactivate the SQL Server 2005 service to reduce the memory overhead, which I typically do with SQL Server Management Studio. After probably stopped the service, also did not launch the SQL Server Management directly, therefore needs the time directly restarts the service to be OK.

This time, to keep the memory to a minimum, all irrelevant windows are closed. Later, when the SQL Server service needs to be re-enabled, the SQL Server management is no longer in the way. Oh, so on the internet to search a few, learned that there are several ways to open and deactivate MS SQL Server servers.

1."Start Menu-> Run

--Start the SQL Server 2005 service

NET start MSSQLServer

--Stop SQL Server 2005 service

net stop MSSQLServer

2."Start Menu-> program->microsoft SQL Server 2005-> Configuration Tool

SQL Server Configuration manager->sql Server (MSSQLSERVER) right-click the start service is successful and the status appears to be running

3."Start Menu-> run->services.msc Service Console

SQL Server (MSSQLSERVER) right-click after successful startup, status is displayed as started

Note: About the 1433 port issue?

TCP/IP and port 1433 are not started by default when SQL Server 2005 is installed, and we can do this in SQL Server Configuration Manager

->sql TCP/IP and 1433 ports are opened under the Native client configuration-> clients protocol.

Well, these methods should be enough to handle the various scenarios that start and stop MS SQL Server.