Error 5 Bringing Resource Online
Contents |
360 games PC games event id 1069 cluster resource 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 microsoft failover cluster event id 1069 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Sql Server Cluster Resource State Check Failed
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 cluster resource failed to come online 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
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server Cluster: SQL Server resource not coming online [sqsrvres] onlinethread: resutilsstartresourceservice failed (status 435) SQL Server > SQL Server Setup & Upgrade Question 0 Sign in
[sqagtres] Onlinethread: Resutilsstartresourceservice Failed (status 435)
to vote Hi Team, We have an issue with bringing online a resource group in SQL Server 2005
Cluster Resource 'sql Server' Of Type 'sql Server' In Clustered Role Failed
Active- Passive cluster. Please find the error message from the log: ----------------------------------------------------------------------------------------------------------- Could not find any IP address that this SQL Server instance depends upon. Make sure that the https://support.microsoft.com/en-us/kb/883732 cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x103. ----------------------------------------------------------------------------- I have checked the dependency of SQL Server and the dependecies are set correctly with SQL Server Network name. The issue arrived after windows production https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cc39d8cb-bc64-48e6-8368-24886481dd4f/sql-server-cluster-sql-server-resource-not-coming-online?forum=sqlsetupandupgrade patching. Please find the extract from cluster log: ERR SQL Server
9 comments I came across this issue many times so thought of sharing resolution with you so that it can save some time. Here is the scenario: You have SQL Server https://sqlactions.com/2012/12/11/sql-server-agent-service-fails-to-come-online-on-one-of-the-node-in-failover-cluster/ instance on 2 node cluster, SQL Agent resource is running fine on one node but if you do a fail-over it fails to come online on the other node. Below are the steps of troubleshooting. As a troubleshooting step we go and check the event log and event log post error message as follows. [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] StartResourceService: cluster resource Failed to start SQLSERVERAGENT service. CurrentState: 1 [sqagtres] OnlineThread: Error 435 bringing resource online. Not getting any clue with above error message, so thought of checking agent error log (SQLAGENT.OUT) to get some more details about service but did not find SQLAGENT.OUT file in the Log folder. Since file itself is not getting generated so started the service from event id 1069 command prompt to get some more information and it will also be helpful to find out if any permission issue is there. Below is the result when service is started from command prompt. Microsoft (R) SQLServerAgent 10.50.4000.0 Copyright (C) Microsoft Corporation. StartServiceCtrlDispatcher failed (error 6) Error 6 indicates "The handle is invalid" We ran procmon. Since SQLAGENT.OUT is not getting generated and from the error it does not look like we have permission issue as command prompt is launched from local administrator account, in procmon we analyzed below entry carefully "1:01:48.8321460 PM","SQLAGENT.EXE","12245","RegQueryValue","HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL10.50.MSSQLSERVER\SQLServerAgent\ErrorLogFile","SUCCESS","Type: REG_SZ, Length: 84, Data: F:\Microsoft SQL Server\MSSQL\Log\" We noticed Error file name SQLAGENT.OUT is missing in the end. To make it 100% sure we compare highlighted (highlighted in red above) with the value present in active node and found working node had below entry. Value in working node: F:\Microsoft SQL Server\MSSQL\Log\SQLAGENT.OUT Value in problem node :F:\Microsoft SQL Server\MSSQL\Log\ We added this file name (SQLAGENT.OUT) in the registry. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\SQLServerAgent\ErrorLogFile New Value "F:\Microsoft SQL Server\MSSQL\Log\SQLAGENT.OUT" After that we started the serv