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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.