Remote server Error...

Hi there. I'm getting the following error when trying to run a query on a
remote server I've set up:
Server 'SERVER_1' is not configured for DATA ACCESS.
I know this option is available for Linked Servers but I dont know why I'm
seeing this problem with a remote server. The Remote Server I've created has
RPC enabled ans is using a valid server name and login.
Any ideas?...Try executing:
exec sp_serveroption 'Server_1', 'data access', 'true'
-Sue
On Wed, 30 Mar 2005 09:49:03 -0800, len
<len@.discussions.microsoft.com> wrote:

>Hi there. I'm getting the following error when trying to run a query on a
>remote server I've set up:
>Server 'SERVER_1' is not configured for DATA ACCESS.
>I know this option is available for Linked Servers but I dont know why I'm
>seeing this problem with a remote server. The Remote Server I've created ha
s
>RPC enabled ans is using a valid server name and login.
>Any ideas?...