I've got a service running as a virtual account (specifically NT Service\MSSQLSERVER), and recently, after my computer changed its account password, the service failed to authenticate with the domain controller, according to our logs. I couldn't even connect using Windows Authentication in SQL Server Management Studio. The strange part is that after restarting the service, everything worked again. Why did this happen? Shouldn't virtual accounts automatically pick up the new password?
3 Answers
Actually, a virtual account should automatically detect the new password. There’s usually an automated process in place for this. Has this happened multiple times, or was it just once? What operating system is running this setup?
If it's happening on a Windows Server 2019 with SQL 2016, it's odd. Normally, a password change in Active Directory means no action is needed if everything is working correctly. Have you tried replicating this issue?
When a computer's machine password changes, it's typically necessary to restart services to recognize the new password. A reboot is often performed after changing the computer machine password. This is standard behavior.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures