Cannot establish remote connection to SQL Server using ODBC

[LSV]

Hello!

We have a Main Office with a LAN including a Server, running SQL Server 2000.

The Workstations (on W2k Pro) all connect to SQL Server (using ODBC) successfully.

Now, take one of those workstations and move it to a remote
office (the remote office is connected to the Main Office via VPN)
This stations (at the remote office) connects to the LAN at the main office and to the Server. One can ping, browse and print from the remote office to the LAN at the main office.

I cannot, however, connect to SQL Server itself. I get an error, both from the client software, or "connection failed" if I'm simply testing the ODBC connection.

Now, I'm repeating exactly what I did with the workstations on the LAN. The same authenticated user, same permissions.

It would appear to me that the router (non existing in the LAN) is causing this problem. Any insight?

Many thanks for your assistance.

--Leandro

 

[mrdenny]

Check to make sure that TCP port 1433 and UDP port 1434 are not being blocked anywhere along the way.

Denny

--Anything is possible. All it takes is a little research. (Me)