How do i Set Password Expiration days for a Sql Login

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

You can add this option while creating the Login. CHECK_EXPIRATION ={ ON }

Keep in mind that it is applicable only to SQL Logins and on Windows Server 2003 and later.

-Roy

haichells SSCrazy Points: 2708 More actions · Answer 2

Hi,

Thanks for your response. How do i set the Interval for Password Expiration.

Jeffrey Williams SSC Guru Points: 90249 More actions · Answer 3

SQL Server uses the Windows password policy mechanism. So, whatever is defined on your server (Windows 2003 or higher) is what will be used.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll