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.
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:
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?
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?
mirroring when principal and mirror are on differe
Posted - 05/30/2012 : 02:05:49
