Sql Server 2008 Authentication Problem, SA Can’t Login !!!!

i just had a problem with SQL 2008, i tried to connect to it using sa or any user using the sql server authentication but no use, it was only accepting the windows authentication, and after searching a lot in the internet , i found that this could be from the mixed mode authentication was not set, and i remember i did that before from a long time !!!!!!!!

Anyway , i didn’t find any place to configure the mixed mode, except from the registry :) so here you go

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.{your sql server instance name}\MSSQLServer\

then change this field LoginMode value to 2 then go to the Sql Server Configuration and restart the sql server 2008 instance

by the way , you may sometimes find only HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\ in case if you have only SqlExpress

That’s it, you are saved now :)