I have a sql server 2005 from which I've created a linked server on an sql server 2008 DB using the following connection string:
'Data Source=192.168.168.14,1433;Network Library=DBMSSOCN;Initial Catalog=EmeraldCalls;Enlist=false'
Note that I'm doing it this way in order to be able to add the Enlist=false flag to be able to execute a stored procedure without being enlisted in a txn (if I create a regular linked server, it won't allow me to execute a SP without setting the 'remote proc transaction promotion' option to false, and since my primary server is 2005, I can't set this option).
The connection is working successfully, and I'm using a user login that has all privileges (similar to sa), but I'm not able to execute any stored procedure (it errors out with "could not find stored procedure..etc")
Any idea on how to fix this?