PROBLEM
This error can be seen when connecting Secret Server to your Microsoft SQL Server database using Windows Authentication. This typically indicates that Secret Server can't create the connection to the database using the identity of the App Pool running Secret Server.
POSSIBLE SOLUTION
It is often caused when using Windows Authentication to connect to the Microsoft SQL Server database using a service account and then that service account's password is changed. To fix this, you will need to go into IIS (Start | Run | inetmgr) and update the password on the service account running the App Pool to use the new password for the service account. Then do an iisreset, or at least recycle the App Pool.
Secret Server should then be able to connect to the Microsoft SQL Server database and the error should no longer occur.
Article ID: 236, Created On: 1/13/2012, Modified: 1/13/2012