Thank you. My issue is actually just with setting up a Linked Server. It appears the problem is that I'm using SQL Server 64 bit and trying to add a linked server that is SQL Server 2000 (32 bit). When I try to run a stored procedure on the remote server, i get this:

OLE DB provider "SQLNCLI10" for linked server "SOMESERVER.COM" returned message "Client unable to establish connection".

Msg 20, Level 16, State 1, Line 0

Encryption not supported on SQL Server.

I'm not sure why "Encryption is the issue", but when setup the same linked server on a 32 bit machine with SQL Server 32 bit, it works fine. :crazy: