Login timeout expired on Win2008R2 and MS SQL 2000 - and using Classic ASP

[POSAPAY]

I have moved a Classic ASP application to a new Windows 2008 R2 server, and installed MS SQL 2000 for it.
All went well until I tried to run the first page of the website, where it says:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver]Login timeout expired



line 102 is simply trying to connect to the server. using ODBC connection.
DRIVER={SQL Server};

I have obviously turned on ASP, and send error to browser and allow all locations to see 500 error details.
The database is up and running according to SQL enterprise manager, where I can access the database, tables and data okay.

I am not sure if I'm missing something for Windows 2008 to allow ODBC connections base don the server name.
Any ideas?

 

[POSAPAY]

BTW, I just tried from Administrative Tools > ODBC Sources to add a System DSN, and got the same error.
I was trying to connect by TCP/IP. and using the server's network name instead of IP.
With IP it wouldn't even go that far.

SQLState: HYT00
SQL Server Error: 0
...Login timeout expired

Any ideas anyone?

 

[POSAPAY]

okay. never mind the question.. just solved it.

I installed SQL 2000 SP4 and it resolved my issue.