Linked server does not work on SQL server instance but work on another
Posted on 2011-10-05
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?