User Login Error

• manoj005

  SSC Veteran

  Points: 247

  More actions

  January 24, 2009 at 10:34 am

  #126944

  Hi,

  I want to change the login for a user 'abc' to the SQL Server authentication.

  I used the following code:

  ALTER LOGIN abc ENABLE

  go

  ALTER LOGIN abc WITH PASSWORD = 'xyz'

  go

  I got an error:

  Msg 15080, Level 16, State 1, Line 1

  Cannot use parameter PASSWORD for a Windows login.

  I need to change it to SQL Server authentication mode.

  How can I do that?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 25, 2009 at 7:20 pm

  #932450

  You cannot "change" a login. You will need to remove the login and then add it back as a Windows login.