Error 42d Sql
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL cluster resource 'sql server' in clustered service or application 'sql server (mssqlserver)' failed Server 2008 High Availability » Error 42d bringing resource online - SQL... Error
Cluster Resource Sql Server Of Type Sql Server In Clustered Role Sql Server Failed
42d bringing resource online - SQL server 2008 R2 cluster instance Rate Topic Display Mode Topic Options Author Message HarryG24HarryG24 cluster resource failed 1069 Posted Wednesday, November 13, 2013 2:49 PM Forum Newbie Group: General Forum Members Last Login: Tuesday, March 10, 2015 1:13 PM Points: 9, Visits: 193 [sqsrvres] OnlineThread: Error 42d bringing resource online
Sql Server Cluster Resource State Check Failed
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 cluster resource sql server agent failed 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 post JavaScript. You cannot post EmotIcons. You cannot post or upload images. Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.
Thread Tools Display Modes [sqsrvres] OnlineThread: Error 42d bringing resource online Steve Guest Posts: n/a 01-12-2004 Hello, Wondering if anyone can assist with this problem. http://www.mssqlforums.com/sqsrvres-onlinethread-error-42d-bringing-resource-online-t11780.html We have SQL 2000 clustered over two servers. SQL runs fine when on http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clustering/2007-06/msg00081.html server 01, but when we try to fail-over SQL to server 02, the MSSQLServer logs the following errors to the NT event log. All have MSSQLSERVER as the source, and all are event ID 17052: [sqsrvres] StartResourceService: StartService (MSSQLSERVER) failed. Error: 42d [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 42d) [sqsrvres] cluster resource OnlineThread: Error 42d bringing resource online. These three error messages are logged another 12 times each (36 messages in total) over the next 12 minutes, and then the SQL Server cluster resource is marked as Failed. I cannot find any information about these errors on Google, this newsgroup, or Microsoft Support. Any assistance would be appreciated. Regards, Steve cluster resource sql Chandrasekar Gopalan Guest Posts: n/a 01-12-2004 Hi Steve - The status info that you got with this error indicates [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 42d). Here 42d is expressed in Hexadecimal. The decimal equivalent is 1069. From the command prompt, c:\> net helpmsg 1069 --> shows "The service did not start due to a logon failure". I would advise you to check the service startup account for both SQL and SQL agent services. Recently if you had changed the password of this windows account, then change the password in the service windows as well. Ensure that the service startup account is same in both the nodes of your cluster. Let me know once you check this. Regards, Chandra -------------------- ||Content-Class: urn:content-classes:message ||From: "Steve" <(E-Mail Removed)> ||Sender: "Steve" <(E-Mail Removed)> ||Subject: [sqsrvres] OnlineThread: Error 42d bringing resource online ||Date: Mon, 12 Jan 2004 04:32:03 -0800 ||Lines: 29 ||Message-ID: <066701c3d908$151f6290$(E-Mail Removed)> ||MIME-Version: 1.0 ||Content-Type: text/plain; || charset="iso-8859-1" ||Content-Transfer-Encoding: 7bit ||X-Newsreader: Microsoft CDO for Windows 2000 ||X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 ||Thread-Index: AcPZCBUfFblUMBZxSTKBegMOTkDDYA== ||Newsgroups: microsoft.public.sqlserver.clustering ||Path: cpmsftngxa07.phx.gbl ||Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.clustering:12437 ||NNTP-
a valid login that you add back the service account that operates the Cluster service. It does not need any special rights, but it will need to log into the server. On both cluster nodes, make sure that the SQL Server service account is a domain account and has the following User Rights assignments: Act as part of the OS Bypass Traverse Checking Lock Pages in Memory Log on as a Batch Job Log on as a Service Replace a Process Level Token http://support.microsoft.com/kb/283811 Anthony Thomas -- "Geoff N. Hiten"