Saturday, May 16, 2009

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 :)

3 comments:

  1. Thanks for this information..really brilliant share..this blog clearly explains about its topic.
    web designing company

    ReplyDelete
  2. Oakleys sunglasses outlet online show you great, and cheap oakley frogskins at lower price online for women and young people. Get this cheap oakleys sunglasses to home!

    ReplyDelete