We run a SQL 2005 cluster on Windows 2008 in Mixed authentication mode. The last two times we have applied a SQL security patch, it automatically changed the auth mode from Mixed to Windows-only, taking our applications offline. Most recently
was today, when we applied KB970892.
Can someone explain why this is happening and how we can prevent it?
View Complete Post