Mirroring Witness getting disappear from Mirroring Setup...

Recently we have faced one issue where DB mirroring witness getting disappear from mirroring setup.

This is happening once Principal get down or SQL services restarts. In the case, we found DB fail-over is also is not working. Once the Principal server come online the DB start serving role as Principal DB and get in sync with Mirror DB without any issue. 

But if we go to DB mirroring property, we found that Witness Server info got washout from the mirroring setup.

Lets me share with you few screenshots which we have taken...

SQL Instances where we have configured DB mirroring on i3 DB with witness and Mirroring Setup Configuration…

Let’s bring down primary server for some time and see the witness status once Primary come online…

 

We can see DB fail over does not happened and Witness got disappear from Mirroring Setup

 

 

Root cause of the issue which we found was...  

The reason behind the issue was, all the members (Principal, Mirror and Witness) having different service account and it was not configured at the time of setting-up the DB mirroring.