Backup Exec 15 catalog error

[Arild_Carlsen]

After moving backupexec database to a new SQL server I started to see tenthousands of warning messages complaining about: ODBC access error. Possible lost connection to database or unsuccsesful access to catalog index in the database.Anyone else having this issue?

[Gurvinder]

You should have one more error accompanying this in the event viewer. Can you provide us that error as well.

[Arild_Carlsen]

I have two events i application log::

1:

Update to catalog index (Catalog index database) failed.
Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]An error occurred in the Microsoft .NET Framework while trying to load assembly id 65603. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS o CCatRecordSet::ExecuteBulkInsert
r:\evans\1180.3142r\becat\segodbc\seg_odbc.cpp(2681)
sp_sproc_columns CatImageInfoProc

2:

Backup Exec Alert: Catalog Error
(Server: "BCKSRV") ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.

[Arild_Carlsen · Accepted solution]

This document solved my problem:

https://vox.veritas.com/t5/Backup-Exec/ODBC-access-error/td-p/772052

Look for the entry from: VJaware

USE bedb;
EXEC Sp_Changedbowner
'sa';
ALTER DATABASE bedb SET TRUSTWORTHY ON;