I also had this problem, and finally figured out it was a permission
issue. Create a sql user and let all the SQL Services on all three
machines use the same credentials to log on.

This will do the trick.

-----Original Message-----
From: Jonathan Baker
[mailto:mssqldba-ezmlmshield-x9746587.[Email address protected]
Sent: Thursday, August 30, 2007 9:46 PM
To: LazyDBA Discussion
Subject: DB Mirroring

Getting stumped with this one, but I cannot appear to see the
destination server from within sql server:

ALTER DATABASE pubs
SET PARTNER =
'TCP://host1.myoffice.COM:5022'

Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://host1.myoffice.COM:5022" 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.

The destination for the mirror, however, does see the source.

I can also telnet into the destination port, and no firewalls exist
between the two machines (and I even turned off the localhost firewall
just to be sure).

Ports are open and evening listening on both sides.

Any ideas?


Jon



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

This message is subject to the disclaimer found at
http://www.macsteel.co.za/emaildisclaimer.jsp

MS Sql Server LazyDBA home page