dbTalk Databases Forums  

SQL 2000 and SQL 2005 on the same Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL 2000 and SQL 2005 on the same Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL 2000 and SQL 2005 on the same Cluster - 01-13-2009 , 08:14 AM






SQL 2005 clustering is not supported on Windows 2000. You need to move up
to Windows 2003 or Windows 2008 clusters.

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


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

Quote:
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 in message
news:OUXCi8MdJHA.6084 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 in message
news:uaiwPQLdJHA.1860 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi Tom

Yes i tried. but no luck. same error.

Regards
Gopi


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote in message
news:uSerLzBdJHA.1860 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
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 in message
news:usOfHr9cJHA.4492 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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 in message
news:uShnQcAcJHA.5976 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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 in message
news:%23Z2qRGAcJHA.1704 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
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










Reply With Quote
  #12  
Old   
Gopi
 
Posts: n/a

Default Re: SQL 2000 and SQL 2005 on the same Cluster - 01-15-2009 , 07:49 AM






Hi

pls find the enviornment details below.

OS: Windows 2003 Enterprise
Model: HP DL580
Memory: 16 GB
Storage: SAN
SQL: SQL 2000 Entperice
Nodes: 2 and both having same patch level and service pack.

Regards
Gopi


"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

Quote:
SQL 2005 clustering is not supported on Windows 2000. You need to move
up to Windows 2003 or Windows 2008 clusters.

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


"Gopi" <gopi2it (AT) gmail (DOT) com> wrote in message
news:OUwzGENdJHA.3792 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 in message
news:OUXCi8MdJHA.6084 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 in message
news:uaiwPQLdJHA.1860 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi Tom

Yes i tried. but no luck. same error.

Regards
Gopi


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote in message
news:uSerLzBdJHA.1860 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
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 in message
news:usOfHr9cJHA.4492 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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 in message
news:uShnQcAcJHA.5976 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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 in message
news:%23Z2qRGAcJHA.1704 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
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












Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.