Is SQL Server Browser Running on your principal, mirror and witness?


Rick Romack
SQL Server Support
IT Data Center, State Compensation Insurance Fund
415-581-8022



-----Original Message-----
From: Jonathan Baker
[mailto:mssqldba-ezmlmshield-x9746587.[Email address protected]
Sent: Thursday, August 30, 2007 12: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 e-mail message from State Compensation Insurance Fund and all attachments transmitted with it may be privileged or confidential and protected from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, copying, or taking any action based on it is strictly prohibited and may have legal consequences. If you have received this e-mail in error, please notify the sender by reply e-mail and destroy the original message and all copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MS Sql Server LazyDBA home page