Skip to main content



Symptoms


When executing a SQL Service SmartObject the user received the following error:

The OLE DB provider "[PROVIDER NAME]" for linked server "[SERVER NAME]" does not contain the table ""[DATABASE NAME"."dbo".""". The table either does not exist or the current user does not have permissions on that table.



Diagnoses


The user had enabled 'Use Native SQL Execution.' This means that rather than returning data from the DB directly we were instead returning a query which in turn fires against a DB to return more focused data. This would be a problem in this situation because the SmartObjects were imported from the staging environment into to dev and so that query was attempting to execute against the DB of the staging environment under the credentials of the service account of the dev environment which did not have rights on the staging server.

Resolution

Disabled 'Use Native SQL Execution'






Be the first to reply!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings