Hey everyone out there! Welcome back to SQL Something!
Today we look at an interesting problem. I'm not sure as to the root cause of it, but we will look at how to solve it.
(P.S. If anyone out there knows why this occurred, please feel free to contribute in the comments below)
The error in question is:
The server instance Witness rejected configure request; read its error log file for more information. The reason 1427, and state 31, can be of use for diagnostics by Microsoft. This is a transient error hence retrying the request is likely to succeed. Correct the cause if any and retry.
 |
| Fig. 1: So it begins. |
I discovered this error repeating continuously in the Application Log in the Windows Event Viewer.
Naturally I checked all the databases currently being mirrored, however all seemed to be in order (both the Principals as well as the Mirrors). So how can we find out more about the issue and how can we fix it?
