How do I fix a login timout in SQL Server 2005 when using a linked server and a stored procedure called from a SQL Agent Job?
SQL Agent will use Shared Memory to connect to the local server.  The Instances will attempt to use named pipes to talk to each other.  You can adjust this by creating an alias in the SQL Server Client Network Utility (cliconfg.exe) and setting the alias to use TCP.