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 :)
0 comments:
Post a Comment