Authenticating with non-domain sql server

  • How would I go about authenticating with a sql server that is not in the domain?  I need to have mutiple sql servers be able to connect with a Sql server not in our domain.

  • Are there any trust relationships established between the domains? If so, in what direction?

    Is the use of SQL Server logins an option?

    K. Brian Kelley
    @kbriankelley

  • Hi,

    No, there is no trust between the domains.  There are sql logins on the target server.  Temporary I have created a duplicate account on the target, and log into the remote server with that login.  I am able to connect using the IP.  But I know there is a way using some sort of UNC pathing (\\sqlserver_IP\instance...).  I just dont know what the complete string is and if it would work.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply