Adding a node to an existing clustered SQL Server instance

Before you begin

Ensure that the following conditions are met:

• An existing clustered SQL Server instance is available within the Management Console.
• A node is available in the Microsoft Windows cluster that can be used for this operation. The node must be managed by BMC Database Automation.
• The node meets all of the SQL Server prerequisites.

To add a node to an existing clustered SQL Server instance

1. From the Management Console, navigate to the SQL Server clustered instance to which you want to add a node.
2. Select Provision > Add Node.

3. In the General page, review the information, and click Next.
4. If you are running SQL Server 2008 and the Utility Upgrades page appears, ensure that Reboot Nodes is selected, and click Next.
   The Utility Upgrades page appears when any of following requirements are not met:
   • Microsoft Windows Installer version 4.5 or later is installed
   • .NET framework 3.5 SP1 or later is installed

5. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.
6. In the Accounts page, enter the domain, user name and password of an account with administrator privileges for all nodes in the cluster in the Remote Account Information section.
7. Enter the remaining account credentials, and click Next.

8. In the Job Options page, specify any of the following Job options, and click Next.

9. If the Change Control page displays, populate the following fields, and click Next.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

10. In the Summary page, review the provisioning information.
    To make changes, do the following:
    1. Click Go to to return to the provisioning step that you want to edit.
    2. Make your changes.
    3. Click Save and Review to return to the Summary page.
11. Specify your verification preferences.
    For additional information, see Understanding-pre-verification-tests.
    • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

    • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      Note

      The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

12. Click Add Node.
    You see a progress page and a success message after the process completes.