I have a server that I've installed sql 2000 standard on Win2003 standard. I've applied sp3. When I run select @@version i get:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I've re-applied sp3a, rebooted, and I still get the same thing, so I THINK this is the latest version.
When I go to network config, network libraries, TCP/IP, the file is SSNETLIB.dll 8.0.766 2/19/2003, does that look right or should it be newer?
I would just leave it alone, but I'm having problems connecting to the db after a reboot. I have to restart the sql service to get my web site to connect again. After it reboots, I cannot even create a ODBC connection to it (over TCP/IP), but I CAN connect to it with named pipes. Restart the sql service, and it works again. This server had MSDE installed on it previously, could that be a problem? I un-installed it before installing sql 2000 standard.
I'm wondering if this has something to do with MSDE previously being installed on this machine. There was a default instance and another named instance too. Maybe there is something in the registry trying to use port 1433.