Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error 42d bringing resource online - SQL server 2008 R2 cluster instance Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 2:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 6, 2013 10:41 AM
Points: 9, Visits: 192
[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!
Post #1514073
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse