Showing posts with label serveri. Show all posts
Showing posts with label serveri. Show all posts

Tuesday, March 20, 2012

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?