Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQL 2000 EE and Windows 2003 Cluster

Author  Topic 

volliefireman
Starting Member

9 Posts

Posted - 2003-07-18 : 16:16:33
I am attempting to install SQL 2000 EE on a Windows 2003 SINGLE-NODE Cluster. I have tried several different ways, but I keep getting an error that a file cannot be found. (In searching the logs the file it cannot find is SQLCLUSTERSETUP.CPP)

I have successfully installed SQL 2000 default and two named instances on the same server on local drives.

We have since added a external disk pack to add cluster capabilities to Windows 2003. Installed the Cluster Service using both a local quorum and the quorum on external drives.

Each attempt to install SQL 2000 has failed at the same point, with the same error.

Is it possible to install SQL 2000 on a single node cluster? I know the books online talks about it, but it assumes that you are running a two node cluster in MSCS.

If it is possible, what are the tricks to getting it to work.

Thanks


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-18 : 16:49:43
Do you have service pack 3a installed for SQL Server? It is a requirement for Windows 2003.

Tara
Go to Top of Page

volliefireman
Starting Member

9 Posts

Posted - 2003-07-18 : 17:31:03
I cannot install SQL2K SP3 until SQL2K is installed.

That is my problem, I cannot get it installed.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-18 : 17:35:14
Ah true! I guess I misread your question. Do you have service pack 4 installed for Windows 2000?

There was a webcast yesterday that MS put on that discussed something similar to your problem. I believe that they mentioned something about SQL Server 2000a had to be installed instead of SQL Server 2000. But that could have been the answer for another problem (I was trying to work at the same time that I was listening to the presentation).



Tara
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2003-07-19 : 01:38:50
try this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;815431

or these:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301520
http://support.microsoft.com/default.aspx?scid=kb;en-us;329329

I have also read that remote registry service needs to be enabled, but I cannot find the link that mentioned that.

-ec



Edited by - eyechart on 07/19/2003 01:46:49
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2003-07-19 : 01:53:20
quote:

I believe that they mentioned something about SQL Server 2000a had to be installed instead of SQL Server 2000.



My understanding is 2000a is the same as the RTM release + the patched ssnetlib.dll library to protect against SQL Slammer. I am not sure why this would be a requirement for install on 2k3, but our ms rep could be wrong about this info.


-ec


Go to Top of Page

volliefireman
Starting Member

9 Posts

Posted - 2003-07-19 : 08:48:01
TDuggan, I am attempting to install SQL 2000 on a Windows 2003 Server Advanced. NOT, W2K.


EyeChart, in order to the articles you refered:

Yes, I tried it but it did not work

Terminal Service is not installed on the system, however Remote Desktop is (for remote admin)

I cannot find a CD that has SQL 2000 with SP2 (or better) integrated. If you can tell me where to get one, I will be happy to try it.


Where can I get SQL 2000a?


Go to Top of Page
   

- Advertisement -