SQL Server Login

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  January 13, 2010 at 10:56 pm

  #141610

  Hi

  I have a created a SQL Server 2005 login with pw password1

  Now I want reset the pw to Password2.

  Could anyone tell me how to do that using SSMS and also TSQL?

  Thank You

  Best Regards

  SQL Buddy

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 14, 2010 at 12:04 am

  #1103446

  sqlbuddy123 (1/13/2010)

  ---

  Hi

  I have a created a SQL Server 2005 login with pw password1

  Now I want reset the pw to Password2.

  Could anyone tell me how to do that using SSMS and also TSQL?

  Thank You

  Best Regards

  SQL Buddy

  SSMS Example:

  http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/

  TSQL

  sp_password 'currentPSWD', 'newPSWD'

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  January 14, 2010 at 9:54 am

  #1103745

  Hi Jason,

  You are always very quick and wonderful. Thank you very much for your help.

  I found another method too..

  ALTER LOGIN Victoria WITH

  PASSWORD = 'V1cteAmanti55imE'

  OLD_PASSWORD = 'B3r1000d#2-36';

  GO

  Thank You,

  Best Regards,

  SQLBuddy

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 14, 2010 at 10:11 am

  #1103764

  It's a matter of timing.

  You're welcome. Good to see that you also found an answer to your question.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events