Post reply

Set authentication mode

  • September 7, 2004 at 4:04 am

    #66530

    My question to you is;

    how-to set autentication mode with Query Analyzer

  • September 7, 2004 at 5:42 am

    #521939

    To my knowledge you can't (or rather shouldn't).  You can easily do this through EM and for the more adventurous via registry hacking (not recommended for ANYONE but an option as a last resort)

    IF you modify it via QA you could invalidate your session and then disconnect yourself.  In EM it warns you (I think).  This is more of a SQL server maintenance/management issue then a code development issue which is where EM does it better...

    Just my opinion.  If I offend anyone I apologize beforehand



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 7, 2004 at 8:27 am

    #521974

    Thanks for your reply and the registry tip. I'm writing a osql script for an MSDE instance, that's why I'm not using EM.

    However, I have now found an article about just that, at MS Knowledge base.

    Thanks again!

  • September 8, 2004 at 11:43 am

    #522172

    The registry key that controls the authentication mode is

    hkey_local_machine\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

    The value that you want to change is Login Mode

    The NT Authentication mode is 1 and for mixed mode the value is 2

     

Viewing 4 posts - 1 through 3 (of 3 total)

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