Why can I not start the "SQL Server (MSSQLSERVER)" service?
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 8.2
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
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
- 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.
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.