December 6, 2006 at 5:19 pm
Hi Guys,
Is it possible to connect two servers which have different domains in SQL SERVER 2005?
I tried to connect it using SQL Server authentication but unfortunately it didn't connect.
Thanks. Your input will be very much appreciated.
Regards,
Mike
December 6, 2006 at 5:31 pm
How you are trying to connect? via linked server call?
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 6:09 pm
Hi Mohammed,
No, I'm still in the registration process. I can't register the machine to the server because they are on a separate domain. Thanks!
Mike
December 8, 2006 at 2:31 am
Are the domains trusted. If the are and you still can't connect you might need to use an IP instead of computer name (you can create an alias as well).
If the domains are not trusted, you're going to have to use sql server authentication.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply