The server network address can not be reached or does not exist. (Microsoft SQL Server, Error: 1418)

This post describes how to fix the error:
An error occurred while starting mirroring.
The server network address can not be reached or does not exist. (Microsoft SQL Server, Error: 1418)

The server network address can not be reached or does not exist. (Microsoft SQL Server, Error: 1418)

Cause

This error appears to be related to network connectivity however the cause in this case was that I had entered incorrect accounts in the Service Accounts step of the Configure Database Mirroring Security Wizard.

Configure database mirroring security wizard service accounts

I verified this by checking the SQL ERRORLOG (by default located here: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log).  This contained the following:

2020-07-03 10:39:31.76 Logon       Database Mirroring login attempt by user 'TEST2019\SQL2019-2K19-1$.' failed with error: 'Connection handshake failed. The login 'NT Service\MSSQL$MIRRORINSTANCE' does not have CONNECT permission on the endpoint. State 84.'.

Resolution

To resolve the issue, first delete the previously created endpoints on each SQL instance (the principal and the mirror):

DROP ENDPOINT Mirroring

Then create the endpoints again ensuring the correct service accounts are used:

Configure database mirroring security wizard correct service accounts

Note: If you try to start mirroring in the user interface:

Database properties start mirroring



Comments

Popular posts from this blog

LG TV This app will now restart to free up more memory

LG TV Clear All Browsing History Data

LG TV turn off Quick Start in settings