Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    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.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    If you have MDAC 2.6 or above, then TCP/IP is selected by default. Also check your Client Network Configuration.

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    My MDAC is 2.7 and I'm using the TCP/IP connection. Also there is no Trusted connection between the two Domains.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •