Both "ODBC access error" and ".NET Framework is disabled" messages are reported

Both "ODBC access error" and ".NET Framework is disabled" messages are reported

Article: 100044873
Last Published: 2019-10-31
Ratings: 1 0
Product(s): Backup Exec

Problem

"Execution of user code in the .NET Framework is disabled" is reported just before the "ODBC access error" message.
SQL server instance for Backup Exec (MSSQL$BKUPEXEC) reports "unloded" messages before the disabled messages while running Backup Exec services.

Error Message

Error    2019/01/15 15:28:09    Backup Exec    34338    None    Backup Exec Alert: Catalog Error
(Server: ""SERVERNAME"") ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.

Error    2019/01/15 15:28:09    Backup Exec CatErrorHandler Server    34327    None    "Update to catalog index (Catalog index database) failed.
Reason:  [Microsoft][ODBC SQL Server Driver][SQL Server]Execution of user code in the .NET Framework is disabled. Enable ""clr enabled"" configuration option. CCatRecordSet::ExecuteBulkInsert
r:\fox\1142r\becat\segodbc\seg_odbc.cpp(2681)
sp_sproc_columns CatImageInfoProc

Information    2019/01/15 15:28:09    MSSQL$BKUPEXEC    6290    Server    AppDomain 7 (BEDB.dbo[ddl].6) unloaded.
Information    2019/01/15 15:28:09    MSSQL$BKUPEXEC    6290    Server    AppDomain 6 (BEDB.dbo[ddl].5) unloaded.
Information    2019/01/15 15:28:08    MSSQL$BKUPEXEC    6290    Server    AppDomain 5 (BEDB.dbo[ddl].4) unloaded.
Information    2019/01/15 15:28:08    MSSQL$BKUPEXEC    6290    Server    AppDomain 4 (BEDB.dbo[ddl].3) unloaded.
Information    2019/01/15 15:28:08    MSSQL$BKUPEXEC    6290    Server    AppDomain 3 (BEDB.dbo[ddl].2) unloaded.
Information    2019/01/15 15:28:08    MSSQL$BKUPEXEC    6290    Server    AppDomain 2 (BEDB.dbo[ddl].1) unloaded.

UMI Code : V-280-2003

Cause

If the "unloaded" messages are reported while running Backup Exec services, those indicate that Common language runtime (CLR) functionality in the SQL instance is disabled from outside of Backup Exec.

Solution

Restart Backup Exec services.
Backup Exec enables the CLR functionality when starting up Backup Exec services.


Follow the next step if restarting Backup Exec service does not resolve the error message - "Execution of user code in the .NET Framework is disabled."

  1. Open command prompt
  2. Start sqlcmd

sqlcmd -E -S .\bkupexec

  1. Execute the following SQL command

1> sp_configure 'clr enabled', 1
2> go
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
1> reconfigure
2> go
1> USE bedb
2> go
Changed database context to 'BEDB'.
1> EXEC sp_changedbowner 'sa'
2> go
1> ALTER DATABASE bedb SET TRUSTWORTHY ON
2> go
1> exit

 

Was this content helpful?