anyone can help me with sql mirror

ali adnan 1 Reputation point

hello i have problem when i setup the mirror i'm using vpn service to connect to sql like but i got this error


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

2 answers

Sort by: Most helpful
  1. MITAL BHADANIYA 1 Reputation point

    check the following:

    1. Make sure there are no network issue. Can you please check if ports used by SQL db are open and accessible on all Principle and Mirror server.
    2. Check Database recovery model, it should be FULL.
    3. Restore Database on Mirror server with NORECOVERY.
    4. Check and verify End Points configure correctly.
    5. Service account is have access on listener.

    Reference Link:

    Hope this will help.


    0 comments No comments

  2. CarrinWu-MSFT 6,866 Reputation points

    Hi @ali adnan ,

    Error 1418 is a connection problem, please check below list first:

    1. check TCP/IP for the instance has been enabled or not
    2. check the system firewall has not block SQL Server port
    3. if you didn't change the SQL Server Port, please make sure that SQL SERVER port is by Default 1433.

    And we recommend that create a database mirroring by T-SQL, please refer to Configure database mirroring

    If it is not work, please refer to SQL SERVER – The server network address “TCP://SQLServer:5023” cannot 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) to get more check list of error 1418.

    Best regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments