April 15, 2009 at 3:13 am
Dear All,
I have installed SQL 2005,SP2 server on two test computers and am trying to get database mirroring to work. Nowitness server is being used.I have done a FULL backup of the database and backed up the transaction log.I have also restored the database and the transactionlog On the mirror server and the database is currently "In Recovery" and seems to always stay that way.When I try to mirror the database I can get the primary and mirror instances to configure,however when I click on "Start Mirroring" with(Synchronous High protection) I get the following error message:
An error occurred while starting mirroring.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://XNSSRV03104.exensys.net: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)
Does anyone have any tips that might be of use?I feel like I'm so
close...
Thanks!!!
April 15, 2009 at 5:22 am
Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
Did you
- tried to ping the servername from the principal?
- checked if port 5022 is open?
- verified the account you use for replication has access to the mirror server and instance?
Wilfred
The best things in life are the simple things
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply