March 20, 2009 at 4:18 am
Hi all..
When I enable database mirrroring, I got the error message
“Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://MIRROR_SERVER:5023" 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. “
But when I chek the error log on primary server it displays the message
"Error: 1474, Severity: 16, State: 1.2009-03-20 15:16:41.98 spid29s Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://mssql:5023'."
and on the mirror server Error log,the msg was
"Database Mirroring login attempt by user 'MSSQL\ACUTE$.' failed with error: 'Connection handshake failed. The login 'MSSQL\Guest' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 192.168.1.222]"
plz help to resolve the issue....
thx..
March 20, 2009 at 6:11 am
you need to grant the account that you use for mirroring access to the mirroring end point on the mirrored database.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply