Windows could not start SQL Server (SQLEXPRESS) on local computer.
In this article we are going to see how to resolve the below error:
Windows could not start SQL Server (SQLEXPRESS) on local computer. For more information, review the system Event log. If this is a non-Microsoft service , contact the service vendor, and refer to service specific error code 17058.
In this article we are going to see how to resolve the below error:
Windows could not start SQL Server (SQLEXPRESS) on local computer. For more information, review the system Event log. If this is a non-Microsoft service , contact the service vendor, and refer to service specific error code 17058.
Due to above error I was also unable to open sqlserver database from the Server Explorer window in Visual Studio 2010. Below steps will resolve this issue and you will be able to open/start sql server.
1. Open run window and type Services.msc. This will open the Services window which lists all the services installed on your system.
2.In the Services windows, Find the SQLServer instance( sort it alphabetically), generally it has SQLEXPRESS as the instance name in parenthesis.
3.Right click on it and go to properties. Then go to LogOn tab and under "Log on as" select the Local System Account. click on Apply button and OK Button.
4. Now start SQL Server. It will be started without any error.
Follow