Mirroring configuration issue

  • pols

    SSC Eights!

    Points: 861


    I am trying to configure the Mirroring in 2008r2. In middle i am getting the error 1418.

    tried changing the service account. but it didn't resolved.

    Tried configure with commands below in both principal and mirror servers.

    alter database abc set partner = 'tcp://node1:5022'

    alter database abc set partner = 'tcp://nod2:5022'

    for some time the database showing as synchronized and within secs the mirroring will go off. I am not able to understand what mistake i am doing.

    I tried tenet the port .. Its working.

    Also i changed the SQL Service account to administrator and domain user account.. same issue i am facing.

    above all everything i tried in Production 2008r2 servers.

    Also i tried setup same in sql2016 test servers. similar issue i am facing. please help to resolve the issue.


  • Beatrix Kiddo


    Points: 32407

    Have you checked that the endpoints are in a STARTED state?

    select * from sys.endpoints

Viewing 2 posts - 1 through 2 (of 2 total)

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