"Mirroring" is not happening in SQL Server Enterprise Edition 2019

Sujit Kumar 1 Reputation point
2021-06-24T10:43:34.29+00:00

Hello,
I need help for creating "Mirror" on SQL Server Enterprise Edition 2019.
Issue is :
Whenever, I am clicking on "Start Mirroring". Its giving error like below.
108967-mirror-issue.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,592 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 40,576 Reputation points
    2021-06-24T11:15:07.76+00:00

    Is there may be a Firewall running blocking port 5022?
    Can you ping the server? Can you connect to address + port using TelNet tool?

    0 comments No comments

  2. CathyJi-MSFT 21,066 Reputation points Microsoft Vendor
    2021-06-25T03:35:31.313+00:00

    Hi @Sujit Kumar ,

    SQL Server Database Mirroring Error 1418 occurs due to connection problem between endpoints. Please try below suggestions one by one.

    1. Make sure your TCP/IP protocol is enabled in SQL server configure manager.
    2. Check if you can telnet to your ports using command TELNET ServerName Ports like “telnet SQLServerName 5022”. Check if the system Firewall has not block SQL Server port. Or you can turn off your firewall.
    3. Verify that the endpoints are started on the partners by using the state or state_desc column the of the sys.database_mirroring_endpoints catalog view. You can start end point by executing an ALTER ENDPOINT statement.
    4. Make sure that service accounts that you are using to run SQL Server services must have CONNECT permission to mirroring endpoints. Suggest you using a domain admin account.
    5. Ensure all instances can access every other partner. Ping each partner from one another.
    6. Sometimes this issue got fixed by dropping the existing endpoint and recreate it again on partner servers.

    Please refer to below blogs to get detail information.

    SQL SERVER – The server network address “TCP://SQLServer: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. (Microsoft SQL Server, Error: 1418)

    HOW TO TACKLE SQL SERVER DATABASE MIRRORING ERROR 1418 ?


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    0 comments No comments