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?...

Remote Server connect error

Hi there.
I'm getting the following error when trying to connect to a Remote Server
I've set up:
Server 'Server_1' is not configured for DATA ACCESS.
I know this option is available with Linked Servers but I dont know what to
do here. I have RPC enabled and valid server and login names defined in the
Remote Server settings.
any ideas?
Try executing:
exec sp_serveroption 'Server_1', 'data access', 'true'
-Sue
On Wed, 30 Mar 2005 09:51:05 -0800, len
<len@.discussions.microsoft.com> wrote:

>Hi there.
>I'm getting the following error when trying to connect to a Remote Server
>I've set up:
>Server 'Server_1' is not configured for DATA ACCESS.
>I know this option is available with Linked Servers but I dont know what to
>do here. I have RPC enabled and valid server and login names defined in the
>Remote Server settings.
>any ideas?

Remote Server connect error

Hi there.
I'm getting the following error when trying to connect to a Remote Server
I've set up:
Server 'Server_1' is not configured for DATA ACCESS.
I know this option is available with Linked Servers but I dont know what to
do here. I have RPC enabled and valid server and login names defined in the
Remote Server settings.
any ideas?Try executing:
exec sp_serveroption 'Server_1', 'data access', 'true'
-Sue
On Wed, 30 Mar 2005 09:51:05 -0800, len
<len@.discussions.microsoft.com> wrote:

>Hi there.
>I'm getting the following error when trying to connect to a Remote Server
>I've set up:
>Server 'Server_1' is not configured for DATA ACCESS.
>I know this option is available with Linked Servers but I dont know what to
>do here. I have RPC enabled and valid server and login names defined in the
>Remote Server settings.
>any ideas?