SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 mirroring when principal and mirror are on differe
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AustraliaDBA
Starting Member

29 Posts

Posted - 05/30/2012 :  02:05:49  Show Profile  Reply with Quote
i am trying to set up database mirroring between 2 servers each are on different domain. spent 3 days read so amny articles tried everything but still getting error....
sql services running under doamin acocunts. both domain accounts are sys admins on both servers.
i can connect to sql server on each server via ssms but when i try to set partner on principal get this error.
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://*** :***" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.


any idea people...

Thanks

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 05/30/2012 :  02:46:10  Show Profile  Reply with Quote
Mirroring between two servers in different domains can be a hassle, try t set it up using sql server accounts and certificates instead and see if that works out better for you:

http://thefirstsql.com/2011/01/05/mirroring-between-two-stand-alone-servers-using-certificates/

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page

AustraliaDBA
Starting Member

29 Posts

Posted - 05/30/2012 :  06:34:20  Show Profile  Reply with Quote
i tried certificates but no luck.. :(

Thanks
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 05/30/2012 :  07:45:11  Show Profile  Reply with Quote
If you really wanted help I'm sure you would've posted the error messages you get or describe the problems you are having right? None os uf here are mind readers, me included.

Are you sure it's not a network issue? What have you done to check this? I assume there are numerous firewalls between the two domains...are you sure data can get through?

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page

robvolk
Most Valuable Yak

USA
15659 Posts

Posted - 05/30/2012 :  09:25:42  Show Profile  Visit robvolk's Homepage  Reply with Quote
Did you check your firewalls (both hardware and software/Windows) to ensure they allow the port you're trying to mirror through are open? Are both TCP/IP and named pipes enabled on both servers? Is the SQL Browser service running on both?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000