May 11, 2011 at 6:18 am
Hi guys,
can we do database mirroring in different domains.Is it possible
can you please provide the answer its very urgent.
Regards
venkat
May 11, 2011 at 2:54 pm
Yes - it is possible. How you go about setting it up depends on how the domains are configured. If the domains are fully trusted - there shouldn't be any issues at all.
If the domains are not trusted - or only use a one way trust from one domain to the other, then you need to use credentials instead.
Lookup database mirroring in books online for full details on how to configure database mirroring across domains.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 11, 2011 at 10:46 pm
Thank you for the answer.
is there any solution.
Regards
venkat
May 11, 2011 at 11:41 pm
Solution provided by Jeffrey Williams is the best solution.
Why are you looking for another solution?
Elaborate more what is the issue you are facing for further help.
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 14, 2013 at 6:52 am
Hi Jeffery,
I need to configure SQL Mirroring across clusters in different domains for multiple SQL instances.
We had two options:-
1. Use certificates which has been rejected by management as it requires SQL Login creation and we cant do that because we have windows authentication for all SQL instances for security reasons.
2. Enable two way trust relationship between domains which is again rejected for security reasons (Though One way trust from production to DR is ok with them)
Hence we are now trying to find out other options, I came across your answer i.e. enable one way trust & use credentials, i am not really able to understand the solution give n by you, also when you say crdentials are you refering to SQL credentials object we create which can be mapped to windows login & if that is the case then how will DR server will connect to Production as windows login mapped to credentials will be in different domains.
Can you please help and explain more about your solution probably give steps followd, that will be really useful.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply