Re: Remote server Error...

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/31/05 

Date: Wed, 30 Mar 2005 20:52:50 -0700

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 has
>RPC enabled ans is using a valid server name and login.
>
>Any ideas?....

Relevant Pages

  • Remote server Error...
    ... I'm getting the following error when trying to run a query on a ... Server 'SERVER_1' is not configured for DATA ACCESS. ... seeing this problem with a remote server. ... RPC enabled ans is using a valid server name and login. ...
    (microsoft.public.sqlserver.security)
  • Re: Distributed Query Strangeness
    ... Hmm...do you have 'data access', 'rpc out' set for the remote server. ... > thanks for the reply, but same result, indefinite hang, no profiler ...
    (microsoft.public.sqlserver.programming)
  • Re: Remote Server connect error
    ... exec sp_serveroption 'Server_1', 'data access', 'true' ... >I'm getting the following error when trying to connect to a Remote Server ... >Server 'Server_1' is not configured for DATA ACCESS. ...
    (microsoft.public.sqlserver.connect)
  • Re: Execute Remote DTS-Package on different Server
    ... That's the good thing about this method is the job has no schedule and is invoked by a user through sp_start_job ... Allan Mitchell ... thanks for your anser, i can not create a job on remote server, ... Maybe there is another possibility for executing this packet directly ...
    (microsoft.public.sqlserver.dts)
  • Re: copying data from one server to another
    ... EXEC sp_addlinkedserver 'RemoteServer', N'SQL Server' ... Based on security settings you may need to map remote server logins. ... Then you just run a normal query referencing the linked server table with 4 ... 'SET IDENTITY_INSERT ON' before execute insert ...
    (comp.databases.ms-sqlserver)