Re: Database mirroring

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Check the following:

1.. Make sure that the mirror database is ready for mirroring.
2.. Make sure that the name and port of the mirror server instance are
correct.
3.. Make sure that the destination mirror server instance is not behind a
firewall.
4.. Make sure that the principal server instance is not behind a firewall.
5.. Verify that the endpoints are started on the partners by using the state
or state_desc column the of the sys.database_mirroring_endpoints catalog
view. If either endpoint is not started, execute an ALTER ENDPOINT statement
to start it.
6.. Make sure that the principal server instance is listening on the port
assigned to its database mirroring endpoint and that and the mirror server
instance is listening on its port. If a partner is not listening on its
assigned port, modify the database mirroring endpoint to listen on a
different port.

7.. Make sure that the SQL Server service account is a Domain account with
connect permission to each endpoint.

Ayad Shammout

"Manish Sukhija" <ManishSukhija@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95381F96-A34A-4D99-9E31-12719452A11D@xxxxxxxxxxxxxxxx
Hi Guys,

I'm trying to configure mirroring among 3 servers,
principal,mirror,witness,
i was able to configure it successfully but when i start mirroring it
gives
this error the server network address "TCP://xx.yy.zz.com:5022" can not be
reached or doesn't exist. check the network address name and that the
ports
for the local and remote endpoints are operational(Microsoft sql server,
Error:1418)

I checked network address, all are correct, i don't why this error is
coming




.

Relevant Pages

  • Re: about mirroring port
    ... >also keep in mind port mirroring on a switch for the most part isn't ... >port mirroring on it. ... >I think it usually just copies the traffic on the switch itself. ... Exploiting Web Applications- A Step-by-Step Attack Analysis ...
    (Focus-IDS)
  • Re: mirroring cable model traffic
    ... Why not just pick up a Cisco 2950 and use port mirroring to accomplish this goal? ... Seams to me that it would be a bit simpler and more stable than an ancient hub or some handmade tap device. ... Subject: mirroring cable model traffic ...
    (Security-Basics)
  • Re: IPSEC problem
    ... anyip to myip, anysourceport to 25 ... 25 to any port. ... Mirroring not checked. ... >> I have a stand alone server. ...
    (microsoft.public.win2000.security)
  • Re: Managed vs unmanaged switch in cluster
    ... the affordable switches are all unmanaged and offer no port ... mirroring capabilities. ... If you are going to buy a WRT54G or WRT54GS you really need to go to the shop ...
    (comp.os.vms)
  • Re: connect to named instance w/ non-default port
    ... it sounds like there is no need to specify the port number in the connection string. ... It listens on port 1434 for SQL Server requests by name/instance and resolves them to the particular port. ... this is well and good because I am troubleshooting a network where the Sql Server instance is reassigned a new listening port on machine restart. ...
    (microsoft.public.sqlserver.connect)