Avatar of MrDavidThorn

asked on 

Linked server does not work on SQL server instance but work on another

Hi Experts

I have a linked server that works fine on the local (default) server istance, I have created a script from the linked server and run it on a different  server instance on the same box with the same credentials.

When I try and query the linked server on the different SQL server instance , I get the error message  that the table doesnt exsit or the current user does not have permissions on that table.

The table does exsit and I can use the same syntax on the default instance and it works as expected.

Has anybody else had this problem and do they know how to resolve it?
Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon