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.
| Author |
Topic |
|
MuadDBA
628 Posts |
 Posted - 2007-09-26 : 10:36:04
|
I am trying to install SQL 2000 Enterprise 32-bit on a Windows 2003 Server (after another team member accidentally uninstalled it).Because of vulnerabilities, I get the warning that I need to install SQL SP3 after completing the 2K install, which I was planning on doign anyway. The problem is that the server will not let me complete the SQL 2K install. When it tries to start up the server to configure it (near the end of the install), it can't connect. When I look in the event viewer, I see this error:quote:
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from
So it looks like it is shutting down my ports before the install can complete. I have tried creating a named pipes alias using clicfg.exe but that doesn't work either. Anyone know what I am supposed to do in this situation? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 10:38:36
|
Install SQL 2000 from CD. Do not start SQL Server.Install SQL Server 2000 SP4. Restart computer.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
MuadDBA
628 Posts |
Posted - 2007-09-26 : 11:04:36
|
| Doesn't work. The install from the CD will not complete. I get an error at the end of the install telling me to check the SQLSTP.LOG and then the install rolls back. |
|
|
|
MuadDBA
628 Posts |
Posted - 2007-09-26 : 11:10:00
|
| FYI, the Errors in the SQLSTP log indicate it is unable to connect to the server to configure it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-26 : 23:22:48
|
| Is sql server service created? |
|
|
|
MuadDBA
628 Posts |
Posted - 2007-09-27 : 09:32:27
|
| I wanted to update this topic to let you all k now I finally got it installed. It appeared that even though the uninstall looked like it completed cleanly, it did not. I swept through the registry and found a few remaining keys which needed to be deleted, and once I did that it was able to install properly and then patch with SP3.Thanks to everyone who helped. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 01:02:18
|
| Why don't apply sp4a? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-28 : 03:02:52
|
| We haven't installed SP4 because of worries about query performance which would require us to do full QA test of all servers stored on our shared web sites ...Its the thing to do with having different datatypes in comparisons in WHERE clauses, or JOINs, or both (sorry, I forget which!) and the implicit casts causing much worse performing query plans after install of SP4.(Although I think there may be a server setting that turns off that behaviour.)Kristen |
|
|
|
|
|
|
|
|
Install SQL 2K on Win2K3 fails, at end of rope.