ger2111
asked on
ODBC connection to remote server
Hi,
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?
Thanks,
Ger.
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?
Thanks,
Ger.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
If connected then no issue
If not then please check remote connection is enabled, Firewall settings, Protocols are enabled
ASKER
using IP rather than server name solcved the issue
Try this link, it might be useful
http://social.msdn.microsoft.com/Forums/en-IE/sqlsecurity/thread/e94fe85c-d069-4d11-8bd5-3d95fea25dc3