Post reply

Windows to Sqlserver Authentication mode

  • December 12, 2008 at 11:34 pm

    #128362

    🙂 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 2:21 am

    #912014

    Check the below KB article to change the authentication mode.

    http://msdn.microsoft.com/en-us/library/ms188670.aspx

    Regards..Vidhya Sagar
    SQL-Articles

  • December 13, 2008 at 2:54 am

    #912019

    udayaraju_v (12/12/2008)

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

    I would very, very strongly recommend that you do not do that. A server with the sysadmin login having a blank password is absolutely asking for various hacks, security violations, stolen information and other such problems.

    sa should have a very strong password, preferably should be disabled and never used.

    Why do you want such a risky config?

    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 13, 2008 at 6:58 am

    #912029

    A user belonging to the windows administrator group will be able to connect to the server using any authentication mode.

    You can also refer to http://msdn.microsoft.com/en-us/library/aa905171(SQL.80).aspx on authentication modes.


    Pradeep Singh

  • December 13, 2008 at 7:41 am

    #912039

    Right click on you server, click on properties and go to the security tab. You can change the authentication mode here. You would require to restart SQL server for this change to take effect.

    I reckon you are installing this on you local PC as you mentioned above for your own use, then blank sa can be used. But as Gail mentioned above, use very strong password in realtime SQL servers at your place of work...

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • December 13, 2008 at 2:26 pm

    #912094

    You could also run this

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

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

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

    Please take special note of the really really strong SA password and do not, under any circumstances leave it blank


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

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

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