Tuesday, March 6, 2012
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.If you have MDAC 2.6 or above, then TCP/IP is selected by default. Also check your Client Network Configuration.|||My MDAC is 2.7 and I'm using the TCP/IP connection. Also there is no Trusted connection between the two Domains.|||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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment