This problem occurred following the migration of Veritas Backup Exec 21 to 22.
The previous database was 32-bit and then during the upgrade was upgraded to 64-bit, creating ownership problems on some tables.
The following two queries will definitely solve the problem.
The Backup Exec console shows a lot of such errors:
ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.
Event ID: 34338
Backup Exec Alert: Catalog Error
(Server: "BE-SERVER01") ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.
Event ID: 34326
Access to catalog index (Catalog index database) failed.
Reason: [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor. CCatRecordSet::Open
R:UNION1193Rbecatsegodbcseg_odbc.cpp(1891)
{ CALL DeleteCatMediaByMediaGuid( ?, ?, ? ) }
Use SQL Studio Management and run these two queries with Backup Exec services turned off.
Query #1
USE bedb
exec sp_configure 'clr enabled', 1
reconfigure
go
Query #2
USE bedb;
EXEC Sp_Changedbowner 'sa';
ALTER DATABASE bedb SET TRUSTWORTHY ON
go
Query #3
USE BEDB TRUNCATE TABLE Dbo.alert
go