Unable to view linked server tables list in SSMS object explorer
0
votes
1
answer
264
views
I'm using SQL2022
I have a linked server to another SQL server, security is set with a defined username/password.
My issue is that when logged into the server with a standard account I cannot see a list of the tables/views on my linked server within the object explorer.
I can query the linked server just fine, but cannot expand the tables tree to see what tables are available.
If I log into the server with my SA account, I can expand the tree and see all the tables and views on the linked server.
What permission do I need to set on my standard login to be able to view the tables in the object explorer.
Asked by Matt
(101 rep)
Aug 20, 2024, 12:54 AM
Last activity: Jun 16, 2025, 07:04 PM
Last activity: Jun 16, 2025, 07:04 PM