troubleshooting Question
Audit mandates MS SQL service accounts expiration: whats practice out there
Audit mandated we must enable password expiry for MS SQL accounts though we say they're service accounts:
from DBA: change cannot be implemented as it will expire service accounts
Set the 'CHECK_EXPIRATION' Option to ON for All SQL Authenticated Logins Within the Sysadmin Role
What's the practice out there?
Can we automate changing the password quarterly & yet not affect service accounts (which I assume
do not need to know the password)? One of them is nagios
Or set the accounts to non-interactive & how to do it for MS SQL?
from DBA: change cannot be implemented as it will expire service accounts
Set the 'CHECK_EXPIRATION' Option to ON for All SQL Authenticated Logins Within the Sysadmin Role
What's the practice out there?
Can we automate changing the password quarterly & yet not affect service accounts (which I assume
do not need to know the password)? One of them is nagios
Or set the accounts to non-interactive & how to do it for MS SQL?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.