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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment