Creating an instance of SQL Server 2005 on a node

This topic describes how to create an instance of Microsoft SQL Server 2005 on a node.

Before you begin

• SQL Server media has been 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.
• The node must meet all of the SQL Server prerequisites including:
  • SQL Server 2005 requires Microsoft Windows 2008 or Windows 2003 Server
• If the host is a member of a Windows cluster, credentials for a domain administrator account are required.

To create an instance of SQL Server 2005 on a node

1. From the Management Console, navigate to the node on which you want to add an instance.
2. Select Provision > Add SQL Server Instance.

3. In the Naming page, populate the following fields, and click Next.

4. Populate the fields for the Settings page as follows, and click Next.

5. In the Authentication and Accounts page, populate the following fields, and click Next.

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

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

   Warning

   Note

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

8. 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.
9. 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.

     Warning

     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.

10. Click Add SQL Server Instance.
     You see a progress page and then a success message after the process completes.
    
    The instance now appears in the Contents page for this SQL Server.

11. You might be prompted to restart the node.

    Warning

    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.