I have two server configured with a linked server to a third "master" server. The linked servers both use the same SQL Login security context to get to the master. Both can see and select from the tables. BUT when I try to execute a stored procedure via the linked server, one returns data and the other returns an error message saying that it can't find the stored procedure.
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'MyRemoteDatabase.dbo.MyRemoteSproc'.
The linked server configurations are the same. Both servers are SQL 2008 R2 (build 4339). The CPU and memory are different between them but I can't see how that would matter. The server configuration (sp_configure) seems to be the same and the MSDTC configuration seems to be the same. Any and all suggestions are welcomed...