Error 1418 when setting up the mirroring

Question

Hello,

I have two instances of SQL 2008 SP2 standard in the same subnet hosted on two Windows 2008 R2 in workgroup mode.

The two instances of SQL 2008 SP2 and SQL Server Agent are executed with the 'NETWORK SERVICE' account.

I use authentication based on certificates for connections between endpoints mirror.

I use the 7024 port for mirroring and file Host Name Resolution for SQL servers.

After creating endpoints, certificates and user connections for connection, when I try to initiate the mirroring I get errors:

-----------------------------------
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP: / / preprod1: 7024" can not Be Reached or does not exist. Check the network address name and the ports for That the local and remote endpoints are Operational.
-----------------------------------

If I look in the application logs, I have the following errors:

-------------------
Error: 9650, Severity: 16, State: 3.
-------------------
A cryptographic system call failed DURING a Service Broker or Database Mirroring operation: system error '5 (failed to retrieve text for this error. Reason: 15105) '.
-------------------
Error: 9641, Severity: 16, State: 1.
-------------------
A cryptographic operation failed. This error has serious problem Indicate with SQL Server. Check the SQL Server error log and the Windows event logs for Further information.
-------------------
Database Mirroring login Attempt failed with error: 'Connection handshake failed. An OS call failed: (0) (null). State 53. '. [CLIENT: 192.168.61.51]
-------------------
Error: 1474, Severity: 16, State: 1.
-------------------
Database mirroring connection error 5 'Connection handshake failed. An OS call failed: (0) (null). State 53. " for 'TCP: / / preprod1: 7024'.
-------------------

Do you have any ideas about this type of error?

Best regards,
David.

Answer 1

Hmm I seen this few times ...

1) Try using the IP address instead of the server name.

2) I had issues with setting up Database Mirroring when running under Network Service account.  But since in your case there is no choice, might want to consider creating local service accounts with same name/password on each server and see if imperssation works for you?

Thanks.

---

Mohit K. Gupta --- MCTS, MCITP, MCC2011 http://www.opsvault.com http://sqllearnings.blogspot.com/

Answer 2

Hello,

 

Yes I had try with IP addresses instead name but I have the same error.

I set up a test platform, also using the Network Service account, and I was able to set up the mirroring.

On my production platform, I suspect a problem with the system, but I can not find the source of the error.

Best regards,

David

Answer 3

Have you tried connecting to the server with this account? Error 5 is an access denied message, which normally means that your certificates don't match or the endpoint authenticates with a wrong user. Or even that the user has no Connect-Permission on the endpoint.