You are the database administrator. Users report that SQL Server becomes unavailable. You determine the MSSQL service has stopped. The Windows administrator reports that the password of the service account had expired and was changed. He resets the password on the service to match the new password of the service account. You attempt to restart the service but are unsuccessful. What should you do? Tell the administrator to:

You are the database administrator. Users report that SQL Server becomes unavailable. You determine the MSSQL service has stopped. The Windows administrator reports that the password of the service account had expired and was changed. He resets the password on the service to match the new password of the service account. You attempt to restart the service but are unsuccessful. What should you do? Tell the administrator to:

You are the database administrator. Users report that SQL Server becomes unavailable. You determine the MSSQL service has stopped. The Windows administrator reports that the password of the service account had expired and was changed. He resets the password on the service to match the new password of the service account. You attempt to restart the service but are unsuccessful. What should you do? Tell the administrator to:


Answer – Set Password never expires.

(The administrator probably set the password to “User must change password at next logon.” A service account can’t make that adjustment dynamically; it must be set to “Password never expires.”)