Error: An exception occurred while executing a transact-SQL statement or batch - when running a backup or maintenance task within the Blackbaud Management Console

A user may receive the error, "An exception occurred while executing a transact-SQL statement or batch," when performing a manual backup or maintenance task within the Blackbaud Management Console.

In order to perform maintenance tasks in the Blackbaud Management Console, ensure the Windows account logged onto the server has System Administrator (SA) rights to the SQL Server instance.  Grant these rights in SQL Server and perform your manual backup.   Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.

For more information refer to what rights are required to use Blackbaud Management Console.

Environment

 7.86.93

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.