Re: Remote Server connect error

Try executing:
exec sp_serveroption 'Server_1', 'data access', 'true'

-Sue

On Wed, 30 Mar 2005 09:51:05 -0800, len
<len@xxxxxxxxxxxxxxxxxxxxxxxxx> 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?

.

Relevant Pages

  • Re: copy folder to remote server
    ... copy folder to remote server ... copy folder to remote server ... Your search - madunix - did not match any documents. ...
    (RedHat)
  • RE: [PHP] Communicating with remote server
    ... On the database server, under the control of it's web server, the script ... Communicating with remote server ... both my server and the remote server have webservers with PHP ...
    (php.general)
  • Re: where did all the files go
    ... the local web site folder to a remote test server and delete the local ... the pages to a remote server, are the files that are copied to the remote ... You can then back up the entire folder ... VS2005 has a Publish Web Site option that enables you to publish to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Configuring GNOME to automatically start screensaver after user logged in - Fedora Core 6
    ... I can now remotely connect to the native X display of the ... remote server without having to log into the remote server first ... it presents me with a login and I am able to log in. ...
    (linux.redhat)
  • Trying to understand DCOMs network traffic
    ... I have a server object which runs as an out process exe on my remote ... has been created on the remote server and then goes happily on its way. ... Dim oRemoteServerObj as object ... Dim vResults as variant ...
    (microsoft.public.vb.com)