Hi,
The SA password expired on my SQL server the other day. Services terminated soon thereafter. I've always been told that the password expiration would not result in services being terminated, unless the server was rebooted or services
are refreshed. Am I wrong?
If you are talking about the domain account that your SQL Server is running under - Then Yes, The SQL Server will come to halt if the password for this account expires. You can cross check this in the SQL Server logs & event logs on the host
where your server is installed. It is always recommended(at least in the organizations I have worked) to have the password expiry turned off for the SQL Server service accounts.
If this is normal behavior, is there a way to get around it?
Hence your password is expired now - change the password and supply it to the SQL Server via SQL Server configuration manager>instance properties and re-start the SQL Server. This should bring your SQL Server up & running. To avoid this in the
future enable password never expires option for the SQL Server account @ Active Directory > account properties
Hope this helps
Thanks
Bhanu
