access from different subnets

Hi,

we have a problem that one of our clients has two subnets. Our SQL server is running on W2k Pro in 10.1.0.0 subnet and all clients within same subnet work fine. But clients from 10.2.0.0 subnet cannot access database. Ping and network shares work fine. Only database access seems to be a problem. I am very new to sql so I could use a little help! Thanks in advance

Frank

Hi Frank,

how does your clients connect to the database?

Perhaps you could use:

Code Snippet

Data Source=IP_ADRESS_SQL_SERVER,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server.

Name

Network library

dbnmpntw

Named Pipes

dbmssocn

Winsock TCP/IP

dbmsspxn

SPX/IPX

dbmsvinn

Banyan Vines

dbmsrpcn

Multi-Protocol (Windows RPC)