SQL MIRRORING -- Mirror server can't connect to the Witness RRS feed

  • Question

  • Hello Everyone,

    I have two issue, and help would be appreciated.

    1. I just set up the SQL mirroring. I followed the instruction provided by author Suhas De here and it worked for me, except for one thing. When I checked the Database Mirroring Monitor in the mirror server, I found out that the Mirror is only connected to the Principal, but it is not connected to the Witness. I'm wondering why? I checked the Principal and it shows that it is connected to the Witness and Mirror. Why is it that the Witness can't be seen by the Mirror.

    2. My other issue is that when I try to stop the SQL SERVER service, and restart it again, I can see that the the Witness is not showing up, I had to set/configure again the witness in order for it to show in the session.

    Thanks, everyone.




    Saturday, October 8, 2011 4:25 AM

All replies