PERMISSIONS NEEDED TO SEE LINKED SERVER CATALOG
–1 Execute TSQL
USE MASTER
GO
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN;
–2. Login must be added to Master database as public.
–1 Execute TSQL
USE MASTER
GO
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN;
–2. Login must be added to Master database as public.