Everything for SAP Hana / Basis /Technology / BO / BW

"The following error has occurred: The cluster resource 'SQL Server (InstanceName)' could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)" The following error shows up in the System event log: "Cluster network name resource 'resource_name' failed to create its associated computer object in domain 'ad.weil.com' for the following reason: Unable to create computer account. The text for the associated error code is: Access is denied. Please work with your domain administrator to ensure that: - The cluster identity 'computer_object' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed. - The quota for computer objects has not been reached. - If there is an existing computer object, verify the Cluster Identity 'c...

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start). SQL Server Installation is failed with Wait on the Database Engine recovery handle failed error. I have already posted workaround for that issue, please search about that post. After fixing the SQL Server issue, I observed SQL Server Agent is not starting, To troubleshoot the issue. 1. Connect to SSMS 2. Right click on SQL Server Agent  -- Properties 3. In General section there is path for SQL Server Agent.out error log file. 4. Open the file in notepad and verify the error, I have the following error in my agent.out file Unable to connect to server '(local)'; SQLServerAgent cannot start SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000] Logon to server '(local)' failed (DisableAgentXPs) SQLServerAgent terminated (normally) 5. To fix this I have added NT Authoriy\System to SQL Security, (The cause of...