Remote server Error...

From: len (len_at_discussions.microsoft.com)
Date: 03/30/05

  • Next message: Jason Mauss: "Re: Why Windows Authentication?" 
    Date: Wed, 30 Mar 2005 09:49:03 -0800

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

  • Next message: Jason Mauss: "Re: Why Windows Authentication?"

    Relevant Pages

    • troubleshooting no response to wmi query on remote server
      ... I've written a perl script to query the event logs on remote servers. ... In checking the wbemcore.log on a problematic remote server, ...
      (microsoft.public.win32.programmer.wmi)
    • Re: missing indexes
      ... My sql version is: Microsoft SQL Server ... >I've simplified the query a little, but it's still causing the error in my ...
      (microsoft.public.sqlserver.programming)
    • WMI Mystery
      ... I have a remote server somewhere, ... Accessing it through WMI Explorer works just fine with a user id + ... I can connect and execute queries correctly. ... Query for operating system name failed. ...
      (microsoft.public.win32.programmer.wmi)
    • Re: Distributed Query Problems
      ... EXEC (@TSQL) ... When I look at the query plan, ... > is actually fetching all 2,000,000 records from the remote server. ...
      (microsoft.public.sqlserver.programming)
    • Re: remote query
      ... Did you meant tuning the "Query" in remote server. ... Open the query and execute using "Execution Plan' ...
      (microsoft.public.sqlserver.server)