Browse FAQs

Why can I not start the "SQL Server (MSSQLSERVER)" service?

Published date: 18 June 2020

Issue
User is unable to start the "SQL Server (MSSQLSERVER)" service on PME server. When a user tries to start the service the following error pops up "Windows could not start the SQL server (MSSQLSERVER) on Local Computer... (error code 3417)". Below is a screen shot of the error message. 



Product Line
Power Monitoring Expert 2020
Power Monitoring Expert 9.x
Power Monitoring Expert 8.x

Environment 
Windows Services

Cause
There are multiple known causes for this issue. The SQL server could have been shut down unexpectedly or the databases could have been moved to a different drive are two possibilities. 

Resolution
The error code referenced in the error message indicates that there is a problem with the master database. The most likely problem is the master database is corrupted due to one of the causes listed above. To fix this problem, you will simply need to replace the current master.mdf and mastlog.ldf files with the default template files. To do this, navigate to the following path " C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL". There you will find a folder "Template Data", copy the master.mdf and mastlog.ldf and replace it in the following path "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data folder". That's it, now you should be able to start the "SQL Server (MSSQLSERVER)" service again. 

 

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.