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.
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 1The 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 |
|
AustraliaDBA
Starting Member
38 Posts |
Posted - 2012-05-30 : 06:34:20
|
i tried certificates but no luck.. :(Thanks |
|
|
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?- LumbagoMy blog-> http://thefirstsql.com |
|
|
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? |
|
|
|
|
|