Named Instances

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arun - 23 Jun 2005 02:45 GMT

In SQL 2000 Clustering, can I have only one default instance for the entire
cluster or can I have one default per virtual server. In other words, can
all my SQL installs in a cluster be default, each on a different virtual
server?

Reply to this Message

Rodney R. Fournier [MVP] - 23 Jun 2005 02:51 GMT

1 Default or no default. Then you can have up to 15 named or all 16 can be
named :)

Signature

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

> In SQL 2000 Clustering, can I have only one default instance for the
> entire
> cluster or can I have one default per virtual server. In other words, can
> all my SQL installs in a cluster be default, each on a different virtual
> server?

Reply to this Message

Geoff N. Hiten - 23 Jun 2005 03:41 GMT

Each Instance gets its own virtual server. Due to SQL Instance naming
restrictions, you still only get one default instance per cluster.
Personally, I prefer to use only Named Instances on a cluster, just to keep
name appearances consistent.

Geoff N. Hiten
Microsoft SQL Server MVP

Reply to this Message