How to start sql server

You can start SQL Server by using the Windows Services applet. Open the applet by using the Windows Start, Programs, Administrative Tools, Services menu. Then, double-click the MSSQLServer service, and click Start to start the default instance. If you want to start a SQL Server named instance, look for the service called MSSQL$instancename.

You can also use the sqlservr.exe command to start SQL Server. You need to run the sqlservr.exe program from the inn directory, where the SQL Server binary files are stored by default to start. From the command line, the SQL Server does not run as a service and will shut down when you log off the server.