Run Stored Procedure from SQL Microsoft

[Francisco_SP]

Hi,

I'm trying to run the below script (Stored Procedure) in the load editor. 

LIB CONNECT TO 'Microsoft_SQL_Server_FWSQL001 (freeway_peter bann)';

Load *;

SQL
exec [SP_DS_CLAIMS_SUB] 'D3E975C4D671489DBE22BA63E2B19500', 22, 1, 0, 'CLM';

It retuns the next error message:

The following error occurred:

Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.

Anyone knows how can I fix this error please?

Thanks in advance 🙂

[jaimeaguilar]

Hi, 

I think this has nothing to do with the connection. It is a security config issue, so you may contact the administrator to enable stored procedures executions.

Also, you can try with oledb and odbc connection to see if the error disappears,

regards

[Sue_Macaluso]

@Francisco_SP  Are you using QlikView or Sense?  I would like to move this into the correct product forum. 

[Francisco_SP]

Qlik sense