Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    2

    Unanswered: database mirroring problem

    Hello,

    I got some big problems while trying to set database mirroring, which is the following:

    An error occurred while starting mirroring.
    ------------------------------
    The server network address "xx.xxx.xxx.xxx:5022" 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)

    I have two (VMWare) virtual machines, and each of them I installed an instance of the SQL Server, with exactly the same databases. I would like to use one of them as my mirror server.

    I tried to set up database mirroring from the button "Configure Security" in the "Mirroring" tab. Fortunately, I haven't got problems during the wizard "Configure Security". I can choose not to use a witness server, and I can connect to the other SQL Server on the other virtual machine (as mirror).

    While starting mirroring, the problem exists, as seen on the top. What am I doing wrong?

    I tried to ping from the virtual servers to the other virtual machine. I cannot find any problem while doing this. I also opened some ports in the Windows Firewall (although the Firewall is set to off). The recovery model is also set to 'FULL'.

    I hope someone can help me. I already tried many many times, and any help would be highly appreciated! Thanks.

    EetieD.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Make sure that the service accounts for SQL Server services on the machines involved in the mirroring are explicitly granted the CONNECT permission on the database mirroring endpoints.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •