Error: Database continually goes into suspect status

When launching the Blackbaud Management Console on the server and selecting your Blackbaud product database you may see the following error:
"Database has a status of Suspect or Unknown."

From the workstations you may receive the following error:
"Unable to establish database connection. [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database '[DatabaseName]' requested by the login. The login failed. Native error: 4060."
This issue may occur if your Raiser's Edge, Education Edge, or Financial Edge database has the "Auto Close" option enabled.  To resolve this issue disable the "Auto Close" option on your database.  Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.

You can find additional information from Microsoft for the "Auto Close" option listed below for the following SQL Server versions: Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing the resolution from these websites.

Environment

 Windows 7 (64-bit);Windows 8 (64-bit);Windows 8.1 (64-bit);Windows Server 2008 (32-bit);Windows Server 2008 (64-bit);Windows Server 2008 R2;Windows Server 2012;Windows Server 2012 R2
 SQL Server 2008;SQL Server 2008 R2 Express;SQL Server 2008 R2;SQL Server 2012;SQL Server 2014

Was this article helpful?