Details

Back To All Notes

How to Start MS SQL Server

Open cmd as an administrator and run the following command

net start mssqlserver /T902

If the above command didn't work, try:

  1. Open services
  2. Locate and restart Host Network Service
  3. Start Sql Server (MSSQLSERVER)

If all else fails, visit this blog: https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

I hope this helps.