Error 42d Sql
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
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"