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
