Unanswered: access SQL Server on a different domain
Is there a way to access a SQL Server running on a different domain? I can access the same SQL Server from my machine, which is on a different domain using the ODBC connection, but when I try to access it using an application written in VB6.0 then I get the SQL Server does not exist error. I'm using the SQL Authentication method.
Trust does not matter for SQL, unless there is some kind of TCP filtering configured. It seems like in your case there is something else happening with your VB app. What are you using in it to connect? DAO, RDO, ADO, or direct ODBC API's?