Add new instance to an existing SQL Cluster

Dear Experts,

We have a requirement to create a new instance on a existing SQL Server 2008 (Windows 2008) cluster. We have already one instance running on the cluster and we have to create a second clustered instance.

So far, I have colected the following:

One non pinging IP address from the same subnet where the server lies.
One domain service account.
Selected a insance name for the new instance.
A 50 GB new disk is already added to the Windows cluster. It has not been added to the existing SQL Resources Group. Its just online now.

I have been reading different blogs but unable to get a clear step by step documentation for doing this. I have not installed SQL cluster before and this requirement is little tricky above that.

I will request your help for the following:

a. what are all the prerequisite resources needed befor starting the installation.

b. Step by step installation procedure.

c. Any special considerations that has to taken care (pre and post installation).

The existing cluster has already a Quorum and MSDTC. So I can use them for the second instance I believe.

Please need guidance on this.

Regards,

asked Jun 19 '12 at 07:27 PM in Default

uttamsahoo
1 ● 1 ● 1

(comments are locked)

1 answer:

Before you start you'll also need a new network name (I would recommend creating the computer object in advance in AD, disabling it and granting full permissions on that to the cluster computer account).

Step-by-step install is a little too much to go into on a forum, I would recommend picking up Allan Hirt's book Pro SQL Server 2008 Failover Clustering which covers everything that you need to know (including a step-by-step walkthrough for installs).

Post install you will need to ensure that you have your memory settings configured correctly perform failover testing for both instances.

answered Jun 20 '12 at 03:10 PM