How To Fix 0Q096 - MSSPROCS execution using DBCON connection &1 is forbidden

0Q096 - Overview

• Message type: E = Error

• Message class: 0Q - Microsoft SQL Server Porting

• Message number: 096

• Message text: MSSPROCS execution using DBCON connection &1 is forbidden

What causes this issue?

You are accessing an ABAP system using a multi-connect database
connection and are attempting to run SQL scripts in this system. This is
not permitted.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Log on to the target system directly or using RFC. Use the standard
database connection for this system. Only then can you execute SQL
scripts.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message 0Q096 - MSSPROCS execution using DBCON connection &1 is forbidden ?

  The SAP error message 0Q096 indicates that there is an issue with executing a stored procedure (MSSPROCS) using a DBCON connection in SAP. The specific message states that the execution of the stored procedure is forbidden for the given connection.
  
  Cause:
  
  Authorization Issues: The user or the connection may not have the necessary permissions to execute the stored procedure. This could be due to missing roles or privileges in the database.
  DBCON Configuration: The DBCON (Database Connection) configuration may not be set up correctly, or it may not allow the execution of stored procedures.
  Database Settings: Certain database settings or restrictions may prevent the execution of stored procedures from external applications.
  Network Issues: There could be network-related issues that are preventing the connection from executing the stored procedure.
  
  
  Solution:
  
  Check User Permissions: Ensure that the user associated with the DBCON connection has the necessary permissions to execute the stored procedure. This may involve granting specific roles or