Sunday, February 19, 2012

Installing SQL 2000 on Windows Server 2003

I am trying to install SQL 2000 on a Cluster Server Node
1. MS - Support informed me that I should install this as
a Virtual Server. However, Virtual server is grayed
out. This is a SQL 2000 Standard edition. I do have SLQ
Developer Edition. Does the Version matter here?
I understand their is a problem with SP2 and SP3. Do I
need to just do a local install and then upgrade to
Service Pack 3 and then re-install or something?
Any help would be greatly appreciated.
Tony
inline...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7501c47afc$739fdb60$a501280a@.phx.gbl...
> I am trying to install SQL 2000 on a Cluster Server Node
> 1. MS - Support informed me that I should install this as
> a Virtual Server. However, Virtual server is grayed
> out. This is a SQL 2000 Standard edition. I do have SLQ
> Developer Edition. Does the Version matter here?
>
The OS needs to be 2000 Advanced server with clustering already installed or
2003 Enterprise Edition with clustering already install. SQL in both cases
has to be Enterprise Edition. Nothing else will work.

> I understand their is a problem with SP2 and SP3. Do I
> need to just do a local install and then upgrade to
> Service Pack 3 and then re-install or something?
>
Nope, install after you have clustering running with Enterprise Edition and
then apply service pack 3a. The install and service pack install will go to
all nodes of the cluster.

> Any help would be greatly appreciated.
> Tony
>
|||What about the Developers Edition? I have one of these
that I am not using. Will it work on the Clusters?
Tony
Does this qualify?
>--Original Message--
>inline...
>Cheers,
>Rod
>MVP - Windows Server - Clustering
>http://www.nw-america.com - Clustering
>"Tony" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0a7501c47afc$739fdb60$a501280a@.phx.gbl...
as[vbcol=seagreen]
SLQ
>The OS needs to be 2000 Advanced server with clustering
already installed or
>2003 Enterprise Edition with clustering already install.
SQL in both cases
>has to be Enterprise Edition. Nothing else will work.
>
>Nope, install after you have clustering running with
Enterprise Edition and
>then apply service pack 3a. The install and service pack
install will go to
>all nodes of the cluster.
>
>.
>
|||Its not supported, so I have never tried it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:0c2f01c47b0f$54fbcad0$a501280a@.phx.gbl...[vbcol=seagreen]
> What about the Developers Edition? I have one of these
> that I am not using. Will it work on the Clusters?
> Tony
> Does this qualify?
> message
> as
> SLQ
> already installed or
> SQL in both cases
> Enterprise Edition and
> install will go to
|||SQL Server 2000 Developer Edition supports ALL the features of the Enterprise Edition that allow developers to write and test applications that can use the features. So,
you can use it.
NOTE: The Developer Edition is licensed for use ONLY as a development and test system, NOT a production server.
Additional Information
===================
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Great, that is what I thought. I don't see the Developer Edition on the link
you posted though. Am I right in thinking that its not supported for
Clustering, expect for testing and development.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:D8Ua$rzeEHA.1600@.cpmsftngxa06.phx.gbl...
> SQL Server 2000 Developer Edition supports ALL the features of the
Enterprise Edition that allow developers to write and test applications that
can use the features. So,
> you can use it.
> NOTE: The Developer Edition is licensed for use ONLY as a development and
test system, NOT a production server.
> Additional Information
> ===================
> Features Supported by the Editions of SQL Server 2000
>
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way
> to do this is to visit the following websites:
http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
|||I just checked the link and it does show that Developer Edition SUPPORTS Failover Clustering. Anyways, this link is the online link for the topic "Features Supported by the Editions of SQL Server 2000" in SQL Server
2000 Books Online (BOL). The Developer Edition is licensed for use ONLY as a development and test system, NOT a production server.
HTH,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||In 800 X 600 you can't see the developer Edition column and there is no left
and right scroll bar. DOH! I expanded the screen and answered my own
question. Poor interface on that page
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:9Qn7PCQfEHA.740@.cpmsftngxa06.phx.gbl...
>I just checked the link and it does show that Developer Edition SUPPORTS
>Failover Clustering. Anyways, this link is the online link for the topic
>"Features Supported by the Editions of SQL Server 2000" in SQL Server
> 2000 Books Online (BOL). The Developer Edition is licensed for use ONLY as
> a development and test system, NOT a production server.
> HTH,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

No comments:

Post a Comment