ODBC connection to remote server

I have two domains in two seperate locations. A Domain trust exists between both Domains.
To meet reporting requirements I would like to create an ODBC connection from a Server in domain1 to a server in domain 2.
Is this possible - and if so how?
Who is Participating?
ger2111Author Commented:
I am going to try connecting to Domain2 SQL server using IP and the trusted domain, wont get to test for a number of weeks but for now I will close the question.
Alpesh PatelAssistant ConsultantCommented:
Please try to connect both server from another location.
If connected then no issue
If not then please check remote connection is enabled, Firewall settings, Protocols are enabled
ger2111Author Commented:
using IP rather than server name solcved the issue
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.