I believe this is due to permissions on the remote server as you have to have an account that SQL is running that is also the same on the remote server, which I believe has to be also on ther same domain or ADS. If you run it locally should work fine.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)