CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • The Cluster service failed to bring clustered service or application 'SQLGroup' completely online or offline

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    230
  • Date Created
    Thursday, May 21, 2020
  • This Article Has been Viewed
    666 times
  • Short Desc
    SQL Server High Availability Group may not be able to be brought online or taken offline by the service.
  • Details
    When working with SQL Server High Availability Group, we may sometimes run into the issue where the service is unable to either bring the group online or offline.
    This error can happen when the group is not configured correctly, or if the files have become somehow corrupted.
  • Recreate Issue
    Hard to recreate a scenario where this error will happen.
    I know in my case, I'd been trying for hours to get the SQL Server High Availability Group to work, and it would not function properly. This could have caused some file or data corruption, as most of the databases on the secondary SQL instance, were reporting data loss.
  • Resolve Issue
    Go inside of Active Directory Users and Computer.
    Choose [Computers]
    Search for the computer named [SQLGroup] (Or the name you gave the group)
    Right-Click and [Delete]

    Next
    Open the [DNS Service] running on the DC (Domain Controller)
    Choose [Forward Lookup Zones]
    Search for the Availability Listener [SQLListener] (in our case)
    Right-click, [Delete]
    Repeat the process for [Reverse Lookup Zones]

    Next
    Go back inside [SSMS] (SQL Server Management Studio)
    Right-Click and [Delete] the newly created Availability Group [SQLGroup]
    Start the [Always On High Availability] Wizard.
    The wizard should now complete.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles