Monday, March 26, 2012

Named Instances

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?
1 Default or no default. Then you can have up to 15 named or all 16 can be
named
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Arun" <aganesan@.esurance.com> wrote in message
news:OqFY8U5dFHA.3492@.TK2MSFTNGP14.phx.gbl...
> 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?
>
|||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
"Arun" <aganesan@.esurance.com> wrote in message
news:OqFY8U5dFHA.3492@.TK2MSFTNGP14.phx.gbl...
> 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?
>

No comments:

Post a Comment