SQL Server Mirroring - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server Mirroring

Author

Topic

jpsultana
Starting Member

2 Posts

Posted - 2007-03-21 : 04:35:22

Hi,
We have 2 servers each having a domain (i.e. 2 domains) running

Windows Server 2003
Standard Edition
Service Pack 1

We would like to have one of the servers replicate/mirror the data on to the other but we are getting this error

The error produced from the mirroring part is:

TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'CTSM'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://UM_db_live.UMlive.local:5022" cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Thank you.

Andraax
Aged Yak Warrior

790 Posts

Posted - 2007-03-21 : 05:18:56

Stupid question: have you set up the endpoints for mirroring?

Using something like this:
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS KERBEROS,
ENCRYPTION = SUPPORTED,
ROLE=ALL);

If you have, you seem to have some kind of network problem.

jpsultana
Starting Member

2 Posts

Posted - 2007-03-21 : 09:49:22

Hi, I tried it and got the following:

Msg 7874, Level 16, State 1, Line 1
An endpoint already exists with the bindings specified. Only one endpoint supported for a specific binding. Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.
Msg 7807, Level 16, State 1, Line 1
An error ('0x800700b7') occurred while attempting to register the endpoint 'endpoint_mirroring'.
i also tried

/****** Object: Endpoint [Mirroring] Script Date: 03/21/2007 14:38:43 ******/
CREATE ENDPOINT [Mirroring2]
AUTHORIZATION [UM\Administrator]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)

and got...

Msg 7874, Level 16, State 1, Line 2
An endpoint already exists with the bindings specified. Only one endpoint supported for a specific binding. Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.
Msg 7807, Level 16, State 1, Line 2
An error ('0x800700b7') occurred while attempting to register the endpoint 'Mirroring2'.

Andraax
Aged Yak Warrior

790 Posts

Posted - 2007-03-21 : 10:59:52

OK, then it seems that you already have an endpoint defined. Check the sys.endpoints view to see how it looks and if it's started. If it is correctly defined and started it seems to be a network problem. Do you have routers/firewalls between the servers?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources