I'm newby
but should I say :
Are you compiling the code on the SQL Server ?
IfNot
Did you install the SQL client software&libraries on the second machine and then
compiled from there ?
IfYes WeAreScr... goto end.
ifNot install the SQL CD in your machine then recompile.

partly joking...