MS SQL Server Clustering - SQL Server 2005 side-by-side on cluster with SQL Server 2000

Author

SQL Server 2005 side-by-side on cluster with SQL Server 2000

PavanAllu

2005-09-28, 7:24 am

Hi,

We are using an Active-Passive cluster environment in our project. So far,
we made use of only one instance of SQL Server. i.e SQL Server 2000. New
architectural change is introduced in the current version of the project. We
will have two instances of Database server. One is of SQL Server 2000 and
another is of SQL Server 2005. Tests were successful when we tried this on
single machine. We would like to know how it works on clustered environment.

I want to have an environment where SQL Server 2000 & SQL Server 2005
databases co-exist on an active-passive SQL cluster. I have installed SQL
Server 2005 on cluster. After this, I was trying to install SQL Server 2000
on cluster. The following error message was prompted

“The specified virtual server cannot be maintained by this version of setup.”

Earlier when we were having SQL Server 2000 Cluster and we were trying to
install SQL Server 2005 on same cluster, the Cluster group was not appearing
in the installer.

Please suggest me an approach for preparing this environment.

Thanks in advance

Mike Epprecht \(SQL MVP\)

2005-09-28, 11:24 am

Hi

SQL Server 2005 is still in beta therefore it is not supported for
production use.

SQL Server versions always have to be installed in the order they were
released. SQL Server 2000 before SQL Server 2005.

You need to have each instance with it's own resource groups, in effect, you
have to create a multi instance cluster (active-active in outdated
terminology).

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"PavanAllu" < PavanAllu@discussion
s.microsoft.com> wrote in message
news:FB40069B-D731-4732-9F76- F29C6DE8674F@microso
ft.com...
> Hi,
>
> We are using an Active-Passive cluster environment in our project. So far,
> we made use of only one instance of SQL Server. i.e SQL Server 2000. New
> architectural change is introduced in the current version of the project.
> We
> will have two instances of Database server. One is of SQL Server 2000 and
> another is of SQL Server 2005. Tests were successful when we tried this on
> single machine. We would like to know how it works on clustered
> environment.
>
> I want to have an environment where SQL Server 2000 & SQL Server 2005
> databases co-exist on an active-passive SQL cluster. I have installed SQL
> Server 2005 on cluster. After this, I was trying to install SQL Server
> 2000
> on cluster. The following error message was prompted
>
> "The specified virtual server cannot be maintained by this version of
> setup."
>
> Earlier when we were having SQL Server 2000 Cluster and we were trying to
> install SQL Server 2005 on same cluster, the Cluster group was not
> appearing
> in the installer.
>
> Please suggest me an approach for preparing this environment.
>
>
> Thanks in advance
>

Geoff N. Hiten

2005-09-28, 11:24 am

I have a working test cluster with SQL 2000 and SQL 2005 using Virtual
Server. So far I have found no show stoppers using the September CTP
release. I am still very early in my testing so don't take this as an
absolute guarantee.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"PavanAllu" < PavanAllu@discussion
s.microsoft.com> wrote in message
news:FB40069B-D731-4732-9F76- F29C6DE8674F@microso
ft.com...
> Hi,
>
> We are using an Active-Passive cluster environment in our project. So far,
> we made use of only one instance of SQL Server. i.e SQL Server 2000. New
> architectural change is introduced in the current version of the project.
> We
> will have two instances of Database server. One is of SQL Server 2000 and
> another is of SQL Server 2005. Tests were successful when we tried this on
> single machine. We would like to know how it works on clustered
> environment.
>
> I want to have an environment where SQL Server 2000 & SQL Server 2005
> databases co-exist on an active-passive SQL cluster. I have installed SQL
> Server 2005 on cluster. After this, I was trying to install SQL Server
> 2000
> on cluster. The following error message was prompted
>
> "The specified virtual server cannot be maintained by this version of
> setup."
>
> Earlier when we were having SQL Server 2000 Cluster and we were trying to
> install SQL Server 2005 on same cluster, the Cluster group was not
> appearing
> in the installer.
>
> Please suggest me an approach for preparing this environment.
>
>
> Thanks in advance
>

Anthony Thomas

2005-10-01, 8:23 pm

Also, since each Virtual SQL Server instance has a seperate dedicated set of
binaries, disks, IPs, and Names, the two can run side-by-side,
independently. However, there are upgrades to the Hosts due to the
installation of SS2K5, which may interfere with your SS2K installation, most
notebly, the .NET framework.

Moreover, there are only one set of client tools, but in a mixed enironment,
there would be a set for each version. Absolutely, there is an effect of
the SS2K5 tools on the SS2K tools.

In the past, the recommendation has been that side-by-side installations,
clustered or otherwise, is typically as an upgrade option only. You could
merely upgrade you SS2K instance to SS2K5, but I tend to like clean
installs. The side-by-side option allows you to do this, run each version
for a time being until you get everything off of your SS2K instance, then
uninstall it.

Sincerely,

Anthony Thomas

--

"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
news:uhvxc5DxFHA.2000@TK2MSFTNGP10.phx.gbl...
I have a working test cluster with SQL 2000 and SQL 2005 using Virtual
Server. So far I have found no show stoppers using the September CTP
release. I am still very early in my testing so don't take this as an
absolute guarantee.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"PavanAllu" < PavanAllu@discussion
s.microsoft.com> wrote in message
news:FB40069B-D731-4732-9F76- F29C6DE8674F@microso
ft.com...
> Hi,
>
> We are using an Active-Passive cluster environment in our project. So far,
> we made use of only one instance of SQL Server. i.e SQL Server 2000. New
> architectural change is introduced in the current version of the project.
> We
> will have two instances of Database server. One is of SQL Server 2000 and
> another is of SQL Server 2005. Tests were successful when we tried this on
> single machine. We would like to know how it works on clustered
> environment.
>
> I want to have an environment where SQL Server 2000 & SQL Server 2005
> databases co-exist on an active-passive SQL cluster. I have installed SQL
> Server 2005 on cluster. After this, I was trying to install SQL Server
> 2000
> on cluster. The following error message was prompted
>
> "The specified virtual server cannot be maintained by this version of
> setup."
>
> Earlier when we were having SQL Server 2000 Cluster and we were trying to
> install SQL Server 2005 on same cluster, the Cluster group was not
> appearing
> in the installer.
>
> Please suggest me an approach for preparing this environment.
>
>
> Thanks in advance
>

Sponsored Links