Skip to main content

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

  • August 8, 2023
  • 0 replies
  • 655 views

Luçjano Capo
Forum|alt.badge.img

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 replies.