Error 42d Bringing Resource Online
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home
Cluster Resource Failed 1069
» SQL Server 2008 » SQL Server 2008 High Availability » Error cluster resource 'sql server' in clustered service or application 'sql server (mssqlserver)' failed 42d bringing resource online - SQL... Error 42d bringing resource online - SQL server 2008 R2 cluster instance
Cluster Resource Sql Server Of Type Sql Server In Clustered Role Sql Server Failed
Rate Topic Display Mode Topic Options Author Message HarryG24HarryG24 Posted Wednesday, November 13, 2013 2:49 PM Forum Newbie Group: General Forum Members Last Login: Tuesday, March 10, 2015 1:13 PM sql server cluster resource state check failed Points: 9, Visits: 193 [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 cluster resource sql server agent failed 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 » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You cannot send private messages. You cannot send emails. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot
told me that they were not able to connect to a newly created SQL cluster. Looking at the server name, I remember building the cluster and logged in to troubleshoot the issue. I opened up SSMS but was not able to connect
Cluster Resource Sql Server Agent In Clustered Service Or Application Failed
to the local SQL server! I opened up SSCM and found that the SQL service event id 1069 cluster resource sql server failed was not started. Now the real fun starts: I tried to start the SQL service, the progress bar ran for around 30 seconds
Onlinethread: Error 435 Bringing Resource Online.
and then I got an error saying SQL service could not start and to check the logs. I went to the default SQL logs section and checked, but there were no logs dated for today. I then went http://www.sqlservercentral.com/Forums/Topic1514073-1549-1.aspx to the failover cluster manager checked its logs. I saw the following messages: Cluster resource ‘SQL Server' in clustered service or application ‘SQL server' failed. StartService (MSSQLSERVER) failed. Error: 42d. I checked SSCM to see if the error had anything to do with the location of the master files, if there were any issue with the network protocols, or if the service account used to start SQL server was different. Anyways, to make a long story short, https://stanleyjohns.wordpress.com/2011/10/27/error-42d-bringing-resource-online-sql/ the issue had to do with the service account and AD settings on the cluster. How I fixed the issue was to go to SSCM, and under the ‘Log on' tab, reentered the same account credentials for the SQL server. I hit apply and then started up SQL server successfully. This would have also cause problems when trying to fail over SQL from one node to another. It has something to do with the AD accounts/security policy and is not a SQL server bug. Share this:LinkedInFacebookEmailTwitterGoogleLike this:Like Loading... Related Standard Post navigation → UTF-8 on SQL server. ← Securityadmin vs Sysadmin. Security issue. 3 thoughts on “Error 42d bringing resource online sql.” Satish says: Please add/give SQL service account "logon as service" privilage 2012 at 11:07 am Reply Mircea says: Also when you change the password for the Service account, DO NOT use SQL Server configuration manager, use Windows Services instead 2013 at 5:04 am Reply Marcelo Acevedo says: Please add/give SQL service account “logon as service” privilage. It's works 2014 at 10:00 am Reply Thinking about someting? Leave a Reply... Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using
Server 2008R2 Ent. Cluster Categories: SQL Database by Deepak Hi Friends, Today morning I was just cluster resource logging in Cluster instances to check certain parameters, while checking I found one of the SQL cluster is in failed state. Error Messages in Event logs cluster resource sql are given below: ………………………………………………………………….. [sqsrvres] StartResourceService: StartService (MSSQLSERVER) failed. Error: 42d …………………………………………………………………. ……………………………………………………………………………… [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 42d) …………………………………………………………………………….. ……………………………………………………………………………. [sqsrvres] OnlineThread: Error 42d bringing resource online. ………………………………………………………………………….. Here 42d is expressed in Hexadecimal. The decimal equivalent is 1069. From the command prompt, c:\> net helpmsg 1069 Once you execute the above command to will get the message: "The service did not start due to a logon failure". Solution: First check the service startup account for both