Oddly enough, there appear to be connections from my principle to my
mirror:
Proto Local Address Foreign Address State
TCP 10.20.8.96:5022 10.20.8.86:2281 TIME_WAIT
TCP 10.20.8.96:5022 10.20.8.86:2282 TIME_WAIT
TCP 10.20.8.96:5022 10.20.8.86:2283 TIME_WAIT
TCP 10.20.8.96:5022 10.20.8.86:2284 TIME_WAIT
TCP 10.20.8.96:5022 10.20.8.86:2285 TIME_WAIT
Now I am more perplexed.
-----Original Message-----
From: Jonathan Baker
[mailto:mssqldba-ezmlmshield-x16081638.[Email address protected]
Sent: Thursday, August 30, 2007 4:10 PM
To: LazyDBA Discussion
Subject: RE: DB Mirroring
No witness (no autofailover).
I have tried with the browser service off and on. Same results.
DHCP enabled on both my test servers. No entries in hosts file for
either.
I can ping both ways and telnet to port 5022 both ways as well. Same
DNS server setup. Just cannot set partner from my principle to my
mirror, but can from mirror to principle.
-----Original Message-----
From: Rick Romack
[mailto:mssqldba-ezmlmshield-x75295196.[Email address protected]
Sent: Thursday, August 30, 2007 4:05 PM
To: LazyDBA Discussion
Subject: RE: DB Mirroring
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
MS Sql Server LazyDBA home page