Home > Archive > MS SQL Server > October 2006 > Mirroring Setup Error - Server network address cannot be reached..









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Mirroring Setup Error - Server network address cannot be reached..
Dan

2006-10-24, 6:31 pm

I am trying to configure mirroring on a SQL Server 2005 database.

When I run the Configure Database Mirroring Security Wizard, it completes
and reports that the endpoints configured successfully on the principal,
mirror, and witness servers.

When I start mirroring however I get the following error:
====================
================
An error occurred while starting mirroring.

Alter failed for Database 'mydatabase'. (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

The server network address "TCP://sql1.mydomain.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. (Microsoft SQL Server, Error:
1418)
====================
================

-Running netstat -a shows that the server is indeed listening on port 5022.

-Pinging "sql1.mydomain.com" resolves to the correct IP.

-Telnet sql1.drawnet.com 5022 seems to connect fine.

What else could be causing this error?


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com