December 17, 2009 at 8:35 pm
We have two SQL 2005 Standard Editions with mirroring setup in High Availability mode using the witness (SQL Express). There are 4 DB's that are being mirrored they all can connect to the witness from the principle but not from the mirror (except one can connect to the witness from the mirror)
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 1438
Date: 12/7/2009
Time: 10:01:47 AM
User: N/A
Computer: OXYSQL2
Description:
The server instance Witness rejected configure request; read its error log file for more information. The reason 1451, and state 3, 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.
December 17, 2009 at 10:02 pm
Try this:
Add the IP and the FQDN of the witness to your DNS server. Add the fully qualified domain name of the principal and the witness in the host file of the mirror server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply