Skip to main content
Source Link
Baodad
  • 483
  • 3
  • 8
  • 14

On the SQL Server where the linked server is defined, execute:

Use MASTER
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO public

Does anyone have any comments on the security implications of this?

Post Made Community Wiki by Baodad