1576675 - CoCreateInstance failed. rc: 800703fa

Work Processes fail to connect to the database with error

CoCreateInstance failed. rc: 800703fa.
or
CoCreateInstance failed. rc: 8007007e.

Please note that the error code 800703a can only be found in the developer traces of the affected work processes and is neither included in syslog nor in ABAP dumps.

Still, due to the failed connection attempts you might additionally see:

• Dumps in transaction ST22:

Runtime Errors         DBIF_RSQL_SQL_ERROR
Exception                CX_SY_OPEN_SQL_DB
SQL error in the database when accessing a table.

• Errors in the Syslog (transaction SM21)

***LOG BY2=> sql error -1         performing CON
***LOG BY4=> sql error -1         performing UPD
***LOG BY4=> sql error -1         performing PRE

This KBA only applies if the developer traces show that the connection attempts fail with:

OpenOledbConnection : CoCreateInstance failed. rc: 800703fa.
failed to establish conn

To verify this, open the developer trace of an affected work process in transaction ST11 and look for

CoCreateInstance failed. rc: 800703fa or CoCreateInstance failed. rc: 8007007e.

ABAP-based SAP Application Server running on MS SQL Server

restart, registry key , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem