Post reply

Database Mirroring

  • March 22, 2011 at 3:31 am

    #237138

    I want to set up Mirroing for my databases, however I could not due to error 1418,tried using certificates still with no success could any DBA out there please help me on where I am getting it wrong.

    Regards,

    S.K DBA

  • March 22, 2011 at 3:37 am

    #1301749

    what is the full description of errorr?

    ----------
    Ashish

  • March 22, 2011 at 3:55 am

    #1301758

    The server network address "TCP://sql-server2.domain.local: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

  • March 22, 2011 at 5:45 am

    #1301810

    Hello,

    If you are running SQL Server as a domain account, you must grant login access to both servers.

    ServerA <--> ServerB (mutually authenticate)

    Next, you must grant connect on the endpoints to the service accounts. Finally, check to see that you have the Firewall configured to allow DB Mirroring on port 5022.

    Thanks, Craig

  • March 22, 2011 at 5:51 am

    #1301811

    Run the following query and confirm that the mirroring end point is created successfully?

    select * from sys.database_mirroring_endpoints;

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply