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..
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?
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?
.png "Former Employee"){kind=icon}