Missing DB on linked server 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.

Any ideas?

After executing the following command from the linked server:

select * from [&lt;server&gt;].[&lt;database&gt;].[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.


TLDR;

Problem: I'm not sure how to get one of the databases associated with my linked server to show up.!
This is due to the account used for Linked Servers not being added to the security of the database trying to be accessed.

On the databases that are shown in the Linked Servers container, you will also find the account (back on the original db server) added to the Security section with Read access. Add that account to the newly created db (catalog in this case) on the original server and then refresh the linked servers on the target db server. Your catalog will now show.