Post reply

Any way to setup an Unexpired Windows/SQL Login

  • February 3, 2012 at 1:19 pm

    #250277

    Is there any way to setup an Windows(domain account) or SQL login whose password does not expire?

    Now, SQL Services are running under an DBA's domain account, which expires after a certain period. We want to avoid such situations.

    I am taking a wild guess by assuming that in Windows(domain account), we can give unexpired password setting. Is that the only way?

  • February 3, 2012 at 2:44 pm

    #1442661

    In Active Directory, create a service account for SQL. Then in the account properties, select the account tab, and check "Password never expires" under account options.

  • February 3, 2012 at 5:26 pm

    #1442703

    For SQL Logins, there are check boxes in SSMS that define whether the password expires and if it needs to be changed on the first usage. Set these appropriately and you should be fine.

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

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