ODBC connection to SQL Server Express

[Goondu]

Hi,

First, I do not have any connection issue with ODBC connection the SQL Server. I connects fine when it is on the same network. TCPIP enabled and tried Named Pipes, still failed.

But if the client is on another network, it can't detect the SQL Server.

I am using MS Access to connect to the Server via ODBC. The server OS is Windows 2000 Server.

This is the LAN IP on my end.(no problems here)
LAN 192.168.24.0 (where Server is located IP 196.168.24.110)

This is the LAN IP on my Users.(problems here)
LAN 192.168.22.0

The Routers are connected thru our ISP. There aren't any ports blocking on the Routers or the ISP end.

Does SQL Server Express supports ODBC with different network? I have no problems with Oracle.

I have search MS on this but nothing works. Does any one have a clue about this?

Thanks.

 

[bborissov]

Run SQL Server 2005 Surface Area Configuration (where SQL Server is installed) and check if Remote connections are enabled.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[Goondu]

It's enabled. Radio button checked "Using both TCP/IP and named pipes".

 

[Goondu]

Bump

I have also enable the SQL Browser Service. No such luck.
According to MSDN web site, it should work.

I have also tried the IPALL configuration as suggested, still no luck.

 

[Goondu]

It appears that the "dynamically determine port" is not working correctly.

I had to set it manually.

Setting up MySQL server to try out was without problems.