Mirroring in SQl server 2008

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

Answer 1

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

Answer 2

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_vill | http://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

Answer 3

Check if you have enabled the port in the Firewall?

---

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

Answer 4

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