Avatar of jduran04
jduran04
Flag for United States of America asked on

Event ID 18456 - SQL Server 2014

This error occurs when the IIS site is reported as down, and the database cluster does not automatically failover the database. Running a network capture, but a main architectural issue is that the witness server for SQL Server 2014 resides on the mirror server, and Microsoft strongly recommends it being moved to a separate server.  Has anyone experienced this issue before?
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jduran04

ASKER
The databases are coming up on both servers as mirrored.
Vitor Montalvão

Weird. That only happens when the servers or one server and the witness loses their quorum.
jduran04

ASKER
The more I research, the more it indicates an issue with the witness server, residing on either principal or the mirror server, which Microsoft strongly recommends be installed separately.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Vitor Montalvão

Hi jduran,

Sorry to not coming here before but ran out of ideas. Did you manage to solve this issue?