After a period of normal use, Secret Server suddenly begins to return the following, or similar, error:
Login
failed for user '<insert SQL Server Login account name here>'.
A severe error occurred on the current command. The results, if any,
should be discarded.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user '<insert
SQL Server Login account name here>'.
A severe error occurred on the current command. The results, if any,
should be discarded.
This sudden failure may be because the "Enforce Password Expiration" setting is turned on for the SQL Login Account for Secret Server. In SQL Server Management Studio, turn off this setting by right clicking and selecting "Properties" on the user under the "Security\Logins" folder. On the properties page, uncheck the "Enforce password expiration" checkbox and save.
Article ID: 115, Created On: 10/14/2010, Modified: 10/14/2010