Creating a clustered SQL Server 2008 instance
This topic describes how to add an instance to a clustered Microsoft SQL Server 2008 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 be running Windows Server 2008
- Credentials for a domain administrator account are required.
To add an instance to a clustered SQL Server 2008 instance
- From the Management Console, navigate to the cluster on which you want to add an instance.
- Select Provision > Add Clustered SQL Server Instance.
In the Naming page, populate the following fields, and click Next.
- If the Custom Fields page appears, enter the password, and click Next.
The Custom Fields page appears only when custom fields are defined in the BMC Database Automation XML template used for this provisioning activity. See Adding-custom-fields-to-a-template. In the Cluster Setup page, populate the following fields, and click Next.
In the Settings page, populate the following fields, and click Next.
In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.
- 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. In the Cluster Group Selection page, populate the following fields, and click Next.
In the Cluster Configuration page, populate the following fields, and click Next.
- If 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
In the Domain Groups page, populate the following fields, and click Next.
In the Authentication and Accounts page, populate the following fields, and click Next.
In the Job Options page, specify any of the following Job options, and click Next.
If the Change Control page displays, populate the following fields, and click Next.
- In the Summary page, review the provisioning information.
To make changes, do the following:- Click Go to to return to the provisioning step that you want to edit.
- Make your changes.
- Click Save and Review to return to the Summary page.
- 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.
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.