February 15, 2007 at 8:49 am
We had a recent power outage and all of our servers lost power. When the servers were finally able to be booted one of my clustered sql servers came backup to windows only mode when it was set to mixed mode before. Anyone ever experience anything like that?
February 15, 2007 at 12:01 pm
Hi,
The authentication mode is stored in the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
Value name: loginmode
If it is 1 then it is Windows Only, If it is 2 then it is mixed as I understand.
It is possible that somehow registry got corrupted after hard shutdown and system admins had to restore it from system state backup to the last registry backup. If the mode was changed after last Registry backup, it could explain the change. In this case something else probably changed too.
Regards,Yelena Varsha
February 15, 2007 at 7:36 pm
Nothing was restored. Even if it had been restored this server was setup originally in mixed mode so there would never be any backup of windows only mode.
Thanks for the suggestion.
May 13, 2008 at 9:33 am
After a SQL 2005 install, Is there a way to change the authentication from Windows only to Mixed?
I noticed my sa is not useable anymore.
May 13, 2008 at 10:29 am
Dana
Using Management Studio, right click on the server, then select Security, in there is the option to select server authentication
Marvin Dillard
Senior Consultant
Claraview Inc
May 13, 2008 at 11:04 am
Great, thank you.
May 13, 2008 at 11:06 am
You have to restart service to take effect.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply