Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Document with executing stored procedure doesn't reload within Qlikview manager

I'm executing a stored procedure, which creates a temporary table on the SQL server. It works fine when I reload the script within the Windows editor (on the server). But when I try to reload it on the server within the Qlikview Manager it generates a general error, without any information..

1 Solution

Accepted Solutions

Document with executing stored procedure doesn't reload within Qlikview manager

It appears that you're using Windows Integrated Authentication to connect to your SQLServer.

From your desktop you are authenticating to SQLServer as your own account, but Publisher will be connecting to the database as the Service account. Does this account have access to your Stored Procedure and to the schema where the generated table is created?

1 Reply

Document with executing stored procedure doesn't reload within Qlikview manager

It appears that you're using Windows Integrated Authentication to connect to your SQLServer.

From your desktop you are authenticating to SQLServer as your own account, but Publisher will be connecting to the database as the Service account. Does this account have access to your Stored Procedure and to the schema where the generated table is created?

Community Browser