There is a view that is being called from Server A (SQL 2016) and this view needs to read data from Server B (SQL 2014). There is a linked server set up between these two servers and the connection works fine.
The login that is running the view on the solution/application side is experiencing this error:
The OLE DB provider "SQLNCLI11" for linked server "Server B" does not contain the table ""DB1"."dbo"."TBL1"". The table either does not exist or the current user does not have permissions on that table.'.
-The login has DBO permissions on both DB's in Server A +B.
-The login is listed as a login in the linked server Security page.
-I have explicitly granted select on all tables being accessed, and it did not help.
-I am able to select and read from all tables under Server Objects >Linked Server> Server B > Table> Select To
-When the login runs the view from SSMS, it works fine without any errors.
Can someone please point me in the right direction on why this error might be occurring and how I can resolve it?
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON', but perhapsNT AUTHORITY\ANONYMOUS LOGONhas a login, but lacks permissions to the target table.