Modifying a SQL service group configuration

Last published : Aug 26, 2026
Note the following prerequisites before modifying the SQL service group:
  • If the SQL Server service group is online, you must run the wizard from a node on which the service group is online. You can then use the wizard to add resources to and remove them from the configuration. You cannot change resource attributes.
  • To change the resource attributes, you must take the service group offline. However, the NetAppFiler and NetAppSnapDrive resources for the service group should be online on the node where you run the wizard and offline on all other nodes.
  • If you are running the wizard to remove a node from the service group's system list, do not run the wizard on the node being removed.
  • If you are running the wizard to add or remove NetAppSnapDrive resources for user defined databases, make sure the service group is online.
  • After the application service group configuration, if you have manually edited any of the resource attributes, then you must reset them to their default values. Failing this, the wizard may fail to identify and populate the resources involved in the service group configuration. After you modify the service group configuration you can again edit the resource attributes to set the desired value.
To modify a SQL Server service group
  1. Start the SQL Server Configuration Wizard. Click Start > All Programs > Veritas > Veritas Cluster Server > Configuration Tools > SQL Server Configuration Wizard.
  2. Review the prerequisites and click Next.
  3. In the Service Group Selection panel, select the service group to modify and click Next.
  4. In the Service Group Configuration panel, perform the following actions as necessary:
    • Add or remove systems from the service group's system list.
    • Change the priorty order of the system list.
    • To add (or remove) the selected systems from the service group's AutoStartList attribute, select (or deselect) the Include selected systems in the service group's AutoStartList attribute checkbox.
For information about the AutoStartList attribute, see the Cluster Server Administrator's Guide.
click Next.
  1. In the SQL Server Instance Selection panel, select the SQL Server instance to be made highly available and click Next.
  2. In the User Databases List panel, verify the master and user defined databases configured for the SQL instance. The wizard will create NetAppSnapDrive resource for each database. Click Next.
  3. Follow the wizard instructions and make desired modifications to the service group configuration.