Post reply

change authentication mode

  • November 12, 2011 at 11:46 pm

    #250660

    I set sql server to use windows authentication during setup. How do you change it to sql server authentication/mixed mode after sql server has already been setup? :ermm:

  • November 13, 2011 at 3:44 am

    #1406800

    Right click your server in management studio, goto properties. In the properties window, goto security and change authentication mode.

    You'll need to recycle SQL Server services after that.

  • November 13, 2011 at 8:55 am

    #1406843

    Thanks I'm glad I don't have to re-install SQL Server! 😀

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

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