Tuesday, February 26, 2013

SQL Service status is change pending

SQL Service status is showing status as change pending in the configuration manager.

1. Review the error log file.
2. In our environment we have issue with resourcedb files.
3. I replaced the resource db mdf and ldf files and started the SQL Engine, now it is working fine.

It may vary for every environment, so reveiw the error log file carefully while doing any modifications.

No comments: