none
changeing authentication mode after installation RRS feed

  • Question

  • Is it possible to change authentication mode after sql express has allready been installed?

     

    I have admin rights on the computer and i want to change authentication mode to "sql server and windowns authentications mode".

    Is this possible somehow?

    Maybe by logging in with a trusted conncection?

     

    I need to do it unattended on several computers after they have been installed.

     

    Thursday, December 20, 2007 1:47 PM

Answers

  • As i said in the post i needed to do this unattended...that means that i cant use managements studio.

     

    Anyway i have solved the problem by codeing using SMO objects.

    Friday, December 21, 2007 9:18 AM

All replies

  • (a) Management Studio -->> Server Name -->> Right Click --->> Properties -->> Security -->> Change to Mixed Mode

     

    (b) ALso remember to Enable SA account. By default SA is disabled ( Server -->> Security -->> SA -->> property and enable

     

    (c) Restart the service 

     

     

    Madhu

    Thursday, December 20, 2007 1:58 PM
    Moderator
  • Hi,

    Refer the below KB article.

    How to: Change Server Authentication Mode


    Friday, December 21, 2007 1:33 AM
    Moderator
  • As i said in the post i needed to do this unattended...that means that i cant use managements studio.

     

    Anyway i have solved the problem by codeing using SMO objects.

    Friday, December 21, 2007 9:18 AM