Starting and Restarting Services

You can start or restart an instance of SQL Server automatically or manually. Both the automatic and manual methods start an instance of SQL Server as a Windows 2000 or Windows Server 2003 service. You can start SQL Server with a variety of options such as single-user mode, minimal configuration mode, or with trace flags. You can start SQL Server by starting the SQL Server service from the command prompt.

Note

If you run sqlservr.exe from a command prompt, you cannot pause, stop, or resume an instance of SQL Server using any net commands.

Important

If SQL Server is shut down with open shared memory or a named pipe connection and is then restarted with the credentials of a different user, it may fail to start. This is normal behavior for connection handles controlled by the operating system. To restart SQL Server, end all SQL Server client processes manually or by restarting the computer. Possible errors include "Server shared memory provider failed to initialize. Error: 0x5" and "Server named pipe provider failed to listen on [ \\.\pipe\sql\query ]. Error: 0x5" (The pipe name may vary.)