I'm a bit new to SQL administration.
We are currently experiencing a problem with our Server Authentication Mode.
We need the Server Authentication to be on Mixed Mode (SQL Server and Windows Authentication mode).
But for some strange reason the SQL Server automatically changes this settings to Windows Authentication only. ??
I've gone through the SQL and Windows Logs, and all that I can see is that it seems like the SQL process itself that changes this setting.
Some info. We run SQL 2005 with SP3. SQL Server is part of a Windows 2003 Domain. SQL Server is a member server.
How can I stop the Server Authentication from changing to just Windows Authentication?
What i've also done now is to enable C2 audit tracing, not sure if this might shed some light on the problem.
Thank you for your help.
Does this change occur when you stop and restart the service?
Try stopping the service, note the registry value (see link http://www.mssqltips.com/tip.asp?tip=1441) and then start the service and again note the registry value to see if it changes..