changing authentication mode for already created login

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  March 11, 2004 at 12:35 am

  #84532

  Plz suggest how can i change the authentication mode for already created login,bcz that option comes disabled......

  thanks

• wz700

  SSCertifiable

  Points: 7133

  More actions

  March 11, 2004 at 5:28 am

  #498239

  Authentication mode is a server base option, not an individual base.

  If you change from SQL Server and Windows to Windows only, the existing sql server login will not be used any more.