SQL Server 2008 R2 Multiple instance cluster on Windows 2003

Question

We have a Windows 2003 Enterprise Edition with a default SQL Server 2008 R2 cluster instance (ACSQLCLUSTER). Now they want to add another instance to the cluster. Is it possible on a Windows 2003 server ?. If so what are the steps ? What do I need before the istallation ?

Thank you

Carlos.

Answer 1

Hello Carlos,

Q: Is adding another installation to the cluster possible?

It's possible as long as the resources are presented to the cluster so it can be installed.

Q: If so, what are the steps?

The same steps that were used to install the first instance. http://msdn.microsoft.com/en-us/library/ms179530(v=sql.105).aspx

Q: What do I need before the installation?

You'll need new IP addresses, name, disks, etc.

http://msdn.microsoft.com/en-us/library/bb500442.aspx

http://msdn.microsoft.com/en-us/library/ms189910.aspx

-Sean

---

Sean Gallardy, MCC | Blog

Answer 2

Sean,

Thank you for the info but all these links are for SQL Server 2012. I am not sure if they apply to SQL Server 2008 R2 cluster on WIndows 2003. For fact, there are differences.

Answer 3

Carlos,

At the top of the page there is a link that says "Other versions", click on that and choose 2008R2.

-Sean

---

Sean Gallardy, MCC | Blog

Answer 4

Got it. Thanks.