Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Run Stored Procedure from SQL Microsoft

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 🙂
Labels (2)
3 Replies
Highlighted
Partner
Partner

Re: Run Stored Procedure from SQL Microsoft

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

Highlighted
Community Manager
Community Manager

Re: Run Stored Procedure from SQL Microsoft

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

Sue Macaluso
Highlighted
Contributor II
Contributor II

Re: Run Stored Procedure from SQL Microsoft

Qlik sense