Post reply

Switching from Mixed mode to Windows Authentication

  • September 16, 2008 at 11:10 am

    #382674

    I have never tried to do this before so I'm hoping someone can tell me if its as easy as changing the properties of the server and a reg hack or if its more involved and what the ramifications are of changing back to Windows Authentication mode.

    Thanks

  • September 16, 2008 at 11:19 am

    #872569

    It should be as simple as changing the setting at the instance level. Make sure that you have Windows Accounts that are in the sysadmin group prior to executing the change so that you don't "lock" yourself out from being able to administer the box.

    Not sure what registry hack you are referring to?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • September 16, 2008 at 11:21 am

    #872573

    It's as easy as changing the properties of the server, no hacks necessary. A restart of the SQL instance is required for the change to take effect

    All SQL logins will fail to connect after you switch to windows authent only, so make sure that you've checked everything that should be connecting to your server.

    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

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

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