So there is a linked server. However, I am not currently able to view all databases associated with that linked server from within SSMS after expanding the catalog dropdown. It is my understanding that this may be a permissions issue. However, I am unsure as to which permissions I need to grant in order to interact with tat db from the linked server.
After executing the following command from the linked server:
select * from [<server>].[<database>].[dbo].table1
I receive the following error message:
The OLE DB provider "SQLNCLI10" for linked server "" does not contain the table """."dbo"."table1"". The table either does not exist or the current user does not have permissions on that table.
Problem: I'm not sure how to get one of the databases associated with my linked server to show up.!