I am trying to connect to my SQL server from a client and both have the different gateways, when i try to connect with the server in the same subnet, it connects, but as said above, when i try to connect it through a client machine available in other subnet, it gives an error....
Connection failed:
SQL State: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connt()).
Connection failed:
SQL State: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
Please tell me what to do? and one more thing, my all clients are sharing a single DSN file on a server and through that i am trying to connect to my SQL server, the connectivity betwen both servers are OK. Now please help me in resolving the issue.....