Cannot process the object ""CatalogName"."SchemaName"."TableName"". The OLE DB provider "SQLNCLI11" for linked server "ConnectionName" indicates that either the object has no columns or the current user does not have permissions on that object

  • 8 August 2023
  • 0 replies
  • 265 views

Userlevel 7
Badge

This error comes from the SQL Server, which indicates there are no permissions to read this table. 

We can try to use an OPENQUERY to work around these limitations. 
SELECT * FROM OPENQUERY ('ACUMATICA REST', 'SELECT * FROM [ACUMATICA REST].[CData Acumatica Sys].[Acumatica].[Carrier]');   

Also, make sure that the Linked Server -> Permissions -> Security Panel information are corresponding to the credentials used in your SQL Gateway. 

 

 

 

 

 

 

 


This topic has been closed for comments