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.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2009-04-13 : 07:51:00
|
| 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) |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-13 : 11:18:59
|
| Can the servers ping eachother using the same hostname you listed? Are the firewalls disabled on both machines? |
 |
|
|
|
|
|
Error