Unable to setup a remote ODBC to SQL Server

[netcert]

I'm hoping someone can shed some light on this.

I'm trying to setup a remote ODBC connection on my server to a SQL Server 2000 server that uses MSDE 2000 and runs on a Windows Server 2003 (SBS). I have asked the client to open his firewall on the Server 2003 to allow my server range of IP's.

My server is running Windows Server 2003 Web Edition SP1.

On the client server, they have a db installed on D:\ as a default instance of MSDE 2000 but also have other db's installed on C:\ as named instances.

On my server when setting up the ODBC to them, I'm specifying their external server's IP and using the 'sa' account to login but it always returns the:

[DBNETLIB] ConnectionOpen (PreLoginHandShake()) sql error as well as the:

General Network Error

I cannot ping their IP from my server nor can I ping it from outside my network.

I've also tried setting up the ODBC using their IP\servername to no avail.

Does anyone have any suggestions?

 

[SQLBill]

What type of authentication is the remote SQL Server (MSDE) using? If it is Windows Authentication Only, then the SA account won't work.

-SQLBill

Posting advice: FAQ481-4875

 

[netcert]

nope, mixed-mode. both of them.

they swear their firewall is open and they also just told me they have disabled 'ping'.