I got this error when I was tried to start the SQL Server Services from SQL Server configuration manager. I have mentioned the same screen shot below.
The basic funda to analyze any errors are , first we need to verify SQL Server error logs . In case of SQL Server not able to start then we need to go for windows event logs.
Possible Reasons :
1. Password might be changed due to company security policies.
2. Still server has RTM version only and need to upgrade to latest service packs.
3. There are many instances running on the same machine so this isnstance is unable to start in expected time.
4. Also possible if master database mdf and ldf files are about to corrupt.
Resolutions :
1. Change the updated password :
2. Try to upgrade to next service packs.
3. Stop the unwanted services such as Analysis ,Reporting services and then try to start this instance.
4. In order to solve the master database corrupted issue go to the following path
The basic funda to analyze any errors are , first we need to verify SQL Server error logs . In case of SQL Server not able to start then we need to go for windows event logs.
Possible Reasons :
1. Password might be changed due to company security policies.
2. Still server has RTM version only and need to upgrade to latest service packs.
3. There are many instances running on the same machine so this isnstance is unable to start in expected time.
4. Also possible if master database mdf and ldf files are about to corrupt.
Resolutions :
1. Change the updated password :
Start SQL Server Configuration Manager.
Select SQL Server Services in the left pane.
Right click the service you are trying to start in the right pane and
click Properties.
Enter the new Password and Confirm password.
3. Stop the unwanted services such as Analysis ,Reporting services and then try to start this instance.
4. In order to solve the master database corrupted issue go to the following path
C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL , there you will find a folder ”
Template Data ” , copy the master.mdf and mastlog.ldf and replace it in
C:\Program Files\Microsoft SQL erver\MSSQL10_50.MSSQLSERVER\MSSQL\DATA folder.
5. If the above solutions are not worked out then
Just disable the VIA protocol if it is using 1433 port no from sql server configuration
manager .
No comments:
Post a Comment