Error 42d Bringing Resource Online Sql Server
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 cluster resource failed 1069 » SQL Server 2008 High Availability » Error 42d bringing resource online -
Cluster Resource 'sql Server' In Clustered Service Or Application 'sql Server (mssqlserver)' Failed
SQL... Error 42d bringing resource online - SQL server 2008 R2 cluster instance Rate Topic Display Mode Topic Options Author
Cluster Resource Sql Server Of Type Sql Server In Clustered Role Sql Server Failed
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 Points: 9, Visits: 193 [sqsrvres] OnlineThread: Error 42d bringing resource
Sql Server Cluster Resource State Check Failed
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 cluster resource sql server agent failed 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 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.
360 games PC games cluster resource sql server agent in clustered service or application failed Windows games Windows phone games Entertainment All Entertainment event id 1069 cluster resource sql server failed Movies & TV Music Business & Education Business Students & educators onlinethread: error 435 bringing resource online. Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.sqlservercentral.com/Forums/Topic1514073-1549-1.aspx Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/883732 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Thread Tools Display Modes [sqsrvres] OnlineThread: Error 42d bringing resource online Steve Guest Posts: n/a 01-12-2004 Hello, http://www.mssqlforums.com/sqsrvres-onlinethread-error-42d-bringing-resource-online-t11780.html Wondering if anyone can assist with this problem. We have SQL 2000 clustered over two servers. SQL runs fine when on server 01, but when we http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98813 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 sql server are event ID 17052: [sqsrvres] StartResourceService: StartService (MSSQLSERVER) failed. Error: 42d [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 42d) [sqsrvres] 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 cluster resource sql Failed. I cannot find any information about these errors on Google, this newsgroup, or Microsoft Support. Any assistance would be appreciated. Regards, Steve 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)> ||Send
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums High Availability (2005) SQL Server Not starting Reply to Topic Printer Friendly Author Topic seethem Starting Member Trinidad and Tobago 46 Posts Posted-03/11/2008: 12:00:02 Hello Gurus,I have a 2-node Active/Active cluster. I have 7 SQLSERVER instances (3 on one and 4 on the other)I am attempting to start a SQL Server service on the second node and I keep getting the error messages...Event ID: 19019 [sqsrvres] StartResourceService: StartService (MSSQL$LZ) failed. Error: 422Event ID: 19019[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 422)Event ID: 19019[sqsrvres] OnlineThread: Error 422 bringing resource online.What should I do? rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-03/11/2008: 23:04:54 Check windows event logs and cluster log file for details. seethem Starting Member Trinidad and Tobago 46 Posts Posted-03/12/2008: 01:42:13 1) These are the messages from the Windows Event Logs.2) Where do I find the cluster log file? rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-03/12/2008: 23:13:26 In windows directory on each node. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and Replication (2