Wednesday, March 28, 2012

Multiple instances in a virtual server

We want to create another named instance of SQL Server 2000 (sp 3a) in a SQL
2000 active/active cluster virtual server. We are finding evidence in
several forums (including this one) that we cannot do that : we would need a
new virtual server with its own instance instead. (The problem is our
bespoke software supplier doesn't support that!) Does anybody have any
DEFINITE proof (eg. from Microsoft themselves) that this is the case?
Cheers,
Colin
From BOL. Topic header "Creating a Failover Cluster"
Last bulleted item. 'One Instance...
--SNIP
Elements of a Virtual Server
A virtual server contains:
a.. A combination of one or more disks in a Microsoft Cluster Service
(MSCS) cluster group.
Each MSCS cluster group can contain at most one virtual SQL Server.
b.. A network name for each virtual server. This network name is the
virtual server name.
c.. One or more IP addresses that are used to connect to each virtual
server.
d.. One instance of SQL Server 2000, including a SQL Server resource, a
SQL Server Agent resource, and a full-text resource.
If an administrator uninstalls the instance of SQL Server 2000 within a
virtual server, the virtual server, including all IP addresses and the
network name, is also removed from the MSCS cluster group
--SNIP
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Colin Bunting" <ColinBunting@.discussions.microsoft.com> wrote in message
news:4F3951C7-E521-4FDB-95F0-4C07E2B380E0@.microsoft.com...
> We want to create another named instance of SQL Server 2000 (sp 3a) in a
SQL
> 2000 active/active cluster virtual server. We are finding evidence in
> several forums (including this one) that we cannot do that : we would
need a
> new virtual server with its own instance instead. (The problem is our
> bespoke software supplier doesn't support that!) Does anybody have any
> DEFINITE proof (eg. from Microsoft themselves) that this is the case?
> --
> Cheers,
> Colin
>

No comments:

Post a Comment