Trying to access a SQL database across domains
Posted on 2001-07-17
I am running an application that accesses a SQL 7.0 database. The client (NT 4.0 workstation) that's running the application is in domain A, trying to access the database on an NT Server in domain B. The following is the error being returned:
DB error: 10004 Unable to connect: SQL Server is unavailable or does not exist. , OS Error: 18 ConnectionOpen (sopen()).
The application allows you to specify the server and database when logging in. Have tried specifying the server by ip address and by name and both have failed the same way. Can ping the server successfully by name AND by ip address from the client.
The application gets to the database successfully when running from a client on domain B. Also successful when running from a client on domain A when the database is on a server in domain A.
The application is being run off a server in domain A.
Any thoughts or suggestions would be greately appreciated.