Hi

we are having SQL 2000 in Cluster (Active / Passive) mode. and now we like
to have SQL 2005 instant also in the same cluster. i do understand, we can
have both instance in the same server but how about Cluster enviornment?
what are the steps? any KB or references?

Pls advice.

Regards
Gopi

It's no big deal. Simply install SQL 2000 first and then SQL 2005. You
need separate disk, name and IP resources for each instance.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Hi

we are having SQL 2000 in Cluster (Active / Passive) mode. and now we like
to have SQL 2005 instant also in the same cluster. i do understand, we can
have both instance in the same server but how about Cluster enviornment?
what are the steps? any KB or references?

Pls advice.

Regards
Gopi

Thanks Tom, let me try.

Regards
Gopi

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Not only is it possible, but it is supported in certain configurations.
Here are the rules and recommendations from Microsoft. I have found it best
to stay within their guidelines in this case. Definitely read the section
on Limitations of using mixed SQL Server 2000 and SQL Server 2005 failover
cluster instances.

The Microsoft SQL Server support policy for Microsoft Clustering
http://support.microsoft.com/kb/327518


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Hi Tom

tried but it throughing the following error, any idea?

"Failed to set registry settings for server network libraries. The action is
SetDefaults. The error is 2 (The system cannot find the file specified. "

Regards
Gopi

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Have you tried copying the install CD to a local drive and running it from
there?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Hi Tom

tried but it throughing the following error, any idea?

"Failed to set registry settings for server network libraries. The action is
SetDefaults. The error is 2 (The system cannot find the file specified. "

Regards
Gopi

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Hi Tom

Yes i tried. but no luck. same error.

Regards
Gopi


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

When you do the install, are you using a domain account that is part of the
local Administrators group on each node?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Hi Tom

Yes i tried. but no luck. same error.

Regards
Gopi


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Hi Tom

yes both nodes are part of the domain, i am using one service account and
one security group added in to the admin group (the service account part of
the security group). SQL 2000 Ent with cluster already available and working
fine.

copied the SQL 2005 installation files in to in to the nodes than run the
setup. (.net framework 2)

while in the last step, it gave that error.

Regards
Gopi


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

What are the domain privileges of the account you are using to do the
install? It will have to create groups and the like.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Hi Tom

yes both nodes are part of the domain, i am using one service account and
one security group added in to the admin group (the service account part of
the security group). SQL 2000 Ent with cluster already available and working
fine.

copied the SQL 2005 installation files in to in to the nodes than run the
setup. (.net framework 2)

while in the last step, it gave that error.

Regards
Gopi


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote