Unable to make connection in code...

[logicalunatic]

Problem: I'm unable to connect from one computer's web application to the other computer's SQL server. Get an error about a trusted connection (both servers are already in mixed mode auth?!)

I have two computers here on this network without a domain but in the same workgroup and in the same logical IP network.

I have SQL Server 2000 installed on both using mixed authentication.

I CAN connect using Enterprise Manager without a problem. I tried the steps in the FAQ in this forum and here are the results...

1) Can ping server.
2) Can't telnet!
2X) Verified both are running on port 1433
3) Can file share quite easily.
4) No other machines on network
5) No firewalls turned on (including WinXP SP2 firewall)

The connection strings I'm using in the code WORK when the Data Source = (local) but not when the Data Source = (the other computer or the other computer's IP).

Have Windows XP Pro SP2 on both machines.

What can I do? Thanks

 

[logicalunatic]

UPDATE: I CAN connect using ODBC in Administrative tools.

 

[logicalunatic]

Another fricking update... Discovered this in my Event Log...

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 this version of Windows. 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

http://www.microsoft.com/sql/downloads/default.asp

BAH, I'll update if it doesn't work...

 

[logicalunatic]

I'll update anyway.

Downloaded SP4 and it is now working flawlessly!

Shouldn't I be able to run a vulnerable version if I want to? Sheesh

Thanks