SQL Server Performance Forum – Threads Archive

Multiple instances on SQL cluster

Hi All, I have couple question regarding SQL cluster. 1) I have a two-node active/active cluster server, and I want to install 3 sql 2000 instances on each of the node(total of 6), is this possible? If yes, how many sql enterprise license do I need, 2 (one for each node) or 6 (one for each instance)? 2) Is sql 2000 analysis services runs ok on sql cluster? Thanks & regards,
Vivian

---

1.
You can only have one default instance in an SQL 2000 cluster, all others will be named instances. It’s different from SQL 7 where you could have two "default" instances (and no more). With SQL 2000, the entire cluster acts as a single server and you can install max one default instance and 15 named instances (or 16 named instances). In your case it would be:
SQLCLUSTER
SQLCLUSTERInstance1
SQLCLUSTERInstance2
SQLCLUSTERInstance3
SQLCLUSTERInstance4
SQLCLUSTERInstance5 or
SQLCLUSTERInstance1
SQLCLUSTERInstance2
SQLCLUSTERInstance3
SQLCLUSTERInstance4
SQLCLUSTERInstance5
SQLCLUSTERInstance6 How you divide them between the nodes is up to you. If you divide them among both servers then you need licences for both. If you put all instances on one server and the other is passive, you only need to license one server. 2.
Haven’t run analysis services on a cluster so I can’t say but I assume it’s not much different. /Argyle

---

]]>