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 "<server>" does not contain the table ""<database>"."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.!