Creating a clustered SQL Server 2005 or 2000 instance

This topic describes how to add an instance to a clustered Microsoft SQL Server 2005 or 2000 instance.

Before you begin

  • SQL Server media is installed onto the Manager by using the provided tool. This enables the Manager to automatically download the media to all servers as required when performing the creation of SQL Server instances. See Setting up SQL Server media on the Manager.
  • Cluster Service is installed and a cluster is established between the nodes on which you want to install the clustered instance of SQL Server.
  • The node must meet all of the SQL Server prerequisites including:
    • SQL Server 2005 requires Windows Server 2003
    • SQL Server 2000 requires Windows Server 2003 or Windows 2000 Server
  • Credentials for a domain administrator account are required.

To add an instance to a clustered SQL Server 2005 or 2000 instance

  1. From the Management Console, navigate to the cluster on which you want to add an instance, and select the cluster.
  2. Select Provision > Add Clustered SQL Server Instance.
  3. In the Naming page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  4. In the Cluster Setup page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  5. In the Settings page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  6. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  7. In the Virtual Servers Configuration page, enter the virtual address for the instance in at least one of the sections in the IP Address field (providing more than one virtual address is optional), and click Next.
     This page lists all non-private network interfaces available in the Windows Cluster. The connection names that appear in this step vary depending on your environment.
  8. In the Cluster Group Selection page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  9. In the Cluster Configuration page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  10. In the Domain Groups page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  11. In the Authentication and Accounts page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
  12. In the Job Options page, specify any of the following Job options, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  13. If the Change Control page displays, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

    Note

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

  14. 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.
  15. 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.

  16. Click Create SQL Server Instance.
     A progress page appears followed by a success message upon completion. The instance now appears in the Contents page for this SQL Server. You might be prompted to restart the node. 

    Note

    Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring jobs and viewing job history.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*