locked
Mirroring in SQl server 2008 RRS feed

  • Question

  • Dear All

    Please advice how to solve the issue.

    I have tried most of the solution but noting working.Please help me.


    Srinivasan.S

    Wednesday, February 29, 2012 7:03 AM

Answers

  • Hi All

    Thank you for your reply.Its working fine now.

    The reason for the issue is 

    Main server SQL service is running in Local system

    Mirror server SQL  service is running in network service.

    I have changed both to local system then its working fine. 


    Srinivasan.S


    • Edited by SRINIVASAN.S Sunday, March 4, 2012 1:32 PM
    • Marked as answer by Iric Wen Wednesday, March 7, 2012 3:44 PM
    Sunday, March 4, 2012 1:31 PM

All replies

  • 1.Can you able telnet bi-directional between principal / mirroring and witness servers endpoint ports.

    2. have you granted connect permissions on endpoints to service accounts


    http://uk.linkedin.com/in/ramjaddu


    • Edited by RamJaddu Wednesday, February 29, 2012 9:23 AM
    • Proposed as answer by Janos BerkeMVP Wednesday, February 29, 2012 12:09 PM
    Wednesday, February 29, 2012 9:20 AM
  • On the principal server open a CMD shell ant try below

    TELNET MIRROR_SERVER 5023

    check if responds, Also do the same from the mirror to the principal

    As mentioned on another reply, check the permissions on endpoints for the sql service account


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Wednesday, February 29, 2012 12:03 PM
  • Check if you have enabled the port in the Firewall?

    SKG: Please Marked as Answered, if it resolves your issue.

    Sunday, March 4, 2012 12:40 PM
  • Hi All

    Thank you for your reply.Its working fine now.

    The reason for the issue is 

    Main server SQL service is running in Local system

    Mirror server SQL  service is running in network service.

    I have changed both to local system then its working fine. 


    Srinivasan.S


    • Edited by SRINIVASAN.S Sunday, March 4, 2012 1:32 PM
    • Marked as answer by Iric Wen Wednesday, March 7, 2012 3:44 PM
    Sunday, March 4, 2012 1:31 PM