Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 mirroring when principal and mirror are on differe

Author  Topic 

AustraliaDBA
Starting Member

38 Posts

Posted - 2012-05-30 : 02:05:49
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

3271 Posts

Posted - 2012-05-30 : 02:46:10
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

38 Posts

Posted - 2012-05-30 : 06:34:20
i tried certificates but no luck.. :(

Thanks
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-05-30 : 07:45:11
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

15732 Posts

Posted - 2012-05-30 : 09:25:42
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
   

- Advertisement -