anyone can help me with sql mirror

ali adnan 1 Reputation point
2021-03-09T11:11:30.593+00:00

hello i have problem when i setup the mirror i'm using vpn service to connect to sql like xxx.ddns.net:7352 but i got this error
75760-1.png75871-2.png

75834-3.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.
13,267 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MITAL BHADANIYA 1 Reputation point
    2021-03-09T19:02:36.84+00:00

    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: https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/troubleshoot-database-mirroring-configuration-sql-server?redirectedfrom=MSDN&view=sql-server-ver15

    Hope this will help.

    Cheers!

    0 comments No comments

  2. CarrinWu-MSFT 6,866 Reputation points
    2021-03-10T06:38:01.343+00:00

    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,
    Carrin


    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