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 ***

• Next in forum: SQL Query return unused values
• Prev in forum: help with query
• Thread view: Re: Execute an schedule job from MSDE with LINKED servers in SQL Server

[Reply to this message]