Posted by nigelrivett on 10/17/06 11:54

Check the user that you are connecting with. It is probably the sql
server service account. If this is the local system account you won't
have access to remote machines. It needs to be a domain account.

When you run the sp it is connecting as your login which is why it
works.

www.nigelrivett.net


*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]