SQL Server Performance Forum – Threads Archive
Multiple instances on SQL clusterHi 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,
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:
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