Post reply

Windows to SqlServer Authentication mode

  • December 12, 2008 at 11:31 pm

    #383566

    🙂 Hi Dears

    Hope Everyone are Doing Fine? I have a Prob with installation.. please resovle it.

    I have installed Sqlserver 2005 with Default Instance and Windows Authentication mode in my PC.. Now I have to change these Windows to SQlServer Authentication Mode..These has to be done without uninstalling and reinstalling the Setup..Plz suggest me..how it has to be done..

    I have been to database properties-Security-Mixed mode authentication and restarted..but itz not working..

    I need Login as "sa" and empty Password ""..is ther any possibilty..please suggest me...

    Thanks and Regards ..

    Uday

  • December 13, 2008 at 7:21 am

    #912034

    "If Windows Authentication mode is selected during installation, the sa login is disabled. If you later change authentication mode to SQL Server and Windows Authentication mode, the sa login remains disabled. To enable the sa login, use the ALTER LOGIN statement.

    Security Note:

    It is very important to choose a strong password for the sa login."

    Read further for step by step instructions for how to perform the change you want at BOL:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/79babcf8-19fd-4495-b8eb-453dc575cac0.htm

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • December 13, 2008 at 2:09 pm

    #912090

    EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

    ALTER LOGIN [sa] WITH PASSWORD='the password'; ALTER LOGIN [sa] ENABLE;

    /******* RESTART SQL INSTANCE TO TAKE EFFECT *******/


    Shamless self promotion - read my blog http://sirsql.net

  • December 13, 2008 at 2:28 pm

    #912095

    Please, please do not set a blank password. What requirement could you have to ensure that you have a security vulnerability like that?

    And please don't use sa for development or for your application. Set up a user with rights to connect and use that.

  • December 14, 2008 at 2:42 am

    #912174

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic619044-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 14, 2008 at 5:26 am

    #912184

    Thanq Guys

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply