Today I have faced some serious issues with SQL Server running status. When I tried to connect my SQL database through SQL Server Management studio, the database was not connecting at all, so I checked SQL Server Configuration Manager there and I saw that SQL Server wasn't running at all. After spending a lot of time in the system and blogs on the internet I have checked Windows Logs in Event Viewer and track down the actual error I was getting.
Error code I have found in the Event Viewer
SQL error 9003
After that I got a solution that works perfectly.
Solution:
Go to C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\Templates
Copy and paste model.mdf and modellog.ldf file to below path
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA
After that I have tried to start the SQL Server service and it's started and the database has connected perfectly.
If you have any Question you can contact us or mail us. We will reply you as soon as possible.
Post a Comment