Change password at first logon for SQL Login

• gary1

  SSC-Insane

  Points: 21152

  More actions

  January 27, 2011 at 10:48 am

  #234032

  Hi,

  We are using SQL Authentication for SQL Server 2008.

  I have created users with sqllogins and provided the passwords. But users want to change their password when they first connect the sql instance.

  Could you please advice me

  Thank you

• Surii

  Default port

  Points: 1497

  More actions

  January 27, 2011 at 2:40 pm

  #1279403

  Include the option MUST_CHANGE while creating the Login.

  Ref: http://msdn.microsoft.com/en-us/library/ms189751.aspx