Error 42d bringing resource online - SQL server 2008 R2 cluster instance

  • [sqsrvres] OnlineThread: Error 42d bringing resource online

    Could not find any posts related to this issue with the resolution.

    Just want to share the solution which worked for us.

    Solution:

    Look at the sql server service account which is running under and use the credntials to login to the server and make sure the account is working.

    In our case the service account was locked out and we unlocked the account and re-entered the

    credentials in SQL Server Configuartion manager ( SQL Server services) and brought the services online.

    Hope this helps!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply