This document explains how to install a clustered instance of SQL Server 2008 into an existing cluster containing instances of SQL Server 2005. I prepared these shots from doing a real install into my test cluster, so hopefully they’ll be useful for you.

The process assumes disk partitions for the new cluster group are presented to all nodes in the cluster, but not formatted, mounted or yet added as cluster resources. It is also assumed that each existing instance of SQL Server 2005 is at SP3, and that SQL Server 2005 tools, SSIS, shared components, SSNAC etc is installed on each node and are also at SP3. It is also assumed that you have the new (2008) instance’s virtual IP address allocated, and that you have chosen the instance name, its default location, failover order, disk layout, and all its other install configurations (e.g. Collation, Security Mode, Edition etc). Also your service accounts and security groups should be ready.

Obtain SQL Server 2008 install media. Slipstream Service Pack 1 into your install files (if required) as per this article. This means your single install will become SP1 with no 2-stage install, and less chance of reboot requirements. Copy this install folder to all nodes, in their system partition.

On your designated install node (as chosen by you), run disk administrator and format and label the new partitions, give them drive letter(s), and/or create mount points as per your physical disk layout design. Create the new cluster group for your SQL Server 2008 instance. Add to it the physical disk resources for the new instance.

On the install node, run setup for SQL Server 2008. Install the prerequisites (Windows Installer + .Net Framework 3.0 as necessary.) Install Hotfix KB937444 if the cluster you are installing into is running Windows 2003 server. When the prerequisites complete, run setup again:

clip_image002

From the Installation Center front page, click Installation:

.clip_image004

Chose a New SQL Server Failover cluster installation, and wait for the rules to be run:

clip_image006

 

If the checks complete ok, follow the install of Setup Support Files:

clip_image008

The proceed through the Setup Support Rules:

clip_image010

Enter your Product Key:

Untitled

Accept the License (unless you suddenly change your mind!) ..

clip_image014

Chose which features to install:

clip_image016

In my case, I went for:-
Database Engine Services + Replication + FTI
BIDS
Client Tools Connectivity
Client Tools Backward Compatibility
Integration Services
SQL Server Books Online
Management Tools – Basic + complete

Then complete the Instance Configuration:

clip_image018

Enter your SQL Server network name, named instance name, install directory (C:..).

Confirm the Disk usage summary:

clip_image020

Then enter the Cluster Resource Group selection:

clip_image022

Next, complete the Cluster Disk Selection screen, choosing the disks you created earlier:

clip_image024

Enter the IP address allocated next, in the Cluster Network Configuration:

clip_image026

Enter the Cluster Security policy details:-

clip_image028

Next, enetr the server configuration: type in the service account, and select ‘use same for each service’ if you are running SQL Server and Agent under the same account:-

clip_image030

clip_image032

Then specify the collation:

clip_image034

Then enter the Database Engine Configuration, Account provisioning. This is very important, it’s how you gain administrative access to the server after install!

clip_image036

Specify your data directories:

clip_image038

Filestream (don’t enable – unless you’re going to use it!)

clip_image040

Chose your preference for Error Usage and Reporting:

clip_image042

Then the Cluster Installation Rules are checked:-

clip_image044

You then get a summary:

clip_image046

Click next, and watch it install! Installation Progress:

clip_image048

 

And you’re done! (For the first node only).

You must then run SQL Server 2008 setup on the second node, make all the same selections, but choose ‘Add node to Existing SQL Server 2008 cluster’. Of course, if you are an INI file type, you can do an unattended install (probably slicker and quicker, but I am partial to a bit of interactive fun!).

Go through ‘Setup Support Rules’ and all the same steps, until:

clip_image050

Which is pretty obvious, and thereafter it’s pretty easy. Good luck! I haven’t done the slipstreaming SP1 into the install yet, and I have to do this to our live cluster in 9 days, so wish me luck!

Advertisements

12 thoughts on “Installing a SQL Server 2008 instance into an existing failover cluster of 2005 instances

  1. Thanks for this great info yes. It worked for my \’Installing a SQL Server 2008 instance into an existing failover cluster of 2005 instances\’ project. Do you know why my UltraMon doesn\’t work correctly and I get an access violation at memory address 0x0ACD00189?

  2. I tried using the document you suggested about slip streaming SP1 and it doesn\’t work you scallywag. You\’re no MVP….

  3. Hi Thomas. Thank you for putting this together. Can you tell me the reasoning behind the SQL Server Network Name? I am trying to add three instances to a single SQL Server cluster, and it appears I need a unique network name. I was hoping that the SQL VIP would serve as the network name, but apparently I\’m not understanding the term. Thank you for any help you may provide.

  4. i get error must install hotfix KB937444 to windows server 2003 while setup SQL 2008 cluster but i unknown the way for this fix as MS conduct. Anyone tell me the way how to fix this error?

    1. I did install on the passive node first. You do not need to move the other resources, this is an online operation, with no restarts, so you can leave the existing instances where they are.

  5. Hi! I know this is somewhat off topic but I was wondering if you
    knew where I could locate a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having
    difficulty finding one? Thanks a lot!

  6. Howdy just wanted to give you a quick heads up. The text in
    your post seem to be running off the screen in Chrome.

    I’m not sure if this is a format issue or something to do with web browser compatibility but I thought I’d post to let you know.
    The design look great though! Hope you get the problem solved soon.
    Cheers

  7. Hi,
    Very nice step-by-step article. Well done.
    Have you done this installation on your live cluster for production? What was the result? Did you received any “hidden” holes on the production performance?

    Kind Regards

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s