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?