Re: Remote Server issue...

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/25/03 

Date: Tue, 25 Nov 2003 08:20:11 -0700

Try setting the data access option for the linked server
with sp_serveroption, e.g.
exec sp_serveroption <ServerName>, 'data access', 'true'

-Sue

On Mon, 24 Nov 2003 17:51:04 -0800, "Brett"
<anonymous@discussions.microsoft.com> wrote:

>I am attmepting to setup up a linked server from my
>production server (sql1) to my reporting server (sql2).
>I have replication from sql1 to sql2.
>
>I noticed that there is already a remote server setup on
>sql1 for sql2. It will not allow me to setup a linked
>server for sql2. Plus, I am unable to run a distributed
>query... I get the error message that the remote server
>is not configured from data access.
>
>How do I setup a linked server from sql1 to sql2 so that
>I have data access?
>
>Please advise..
>
>Thank you,
>Brett
>
>I am using SQL Server 2000 for my production and
>reporting servers.

Relevant Pages

  • Re: Excel data consolidation question
    ... it's talking to the server and trying to auto-complete the name ... you can save your form as a Data Access Page ... you know when you save a spreadsheet as HTML and 'add interactivity'? ... it would if you were so incompetent not to check all entries. ...
    (microsoft.public.excel)
  • Re: Excel data consolidation question
    ... The comment on server side and client side controls ends up a little ... Microsoft MVP - Excel ... you can save your form as a Data Access Page ... it would if you were so incompetent not to check all entries. ...
    (microsoft.public.excel)
  • Re: ADO across vpn
    ... Create client/server application that connects to SQL Server or some ... Create a web service the does all the data access and access the web ... >>> We have a vb6 application which connects via ADO to an access ...
    (microsoft.public.vb.database.ado)
  • Re: Data Access Page Frozen
    ... you can do this only on your local machine or ... I've been trying to configure a data access page (created using wizard ... The server is not at home so I've been asking my friend to ... I've gotten "internet server error" and "An error occured while tryin to ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Need a sanity check on CAO and lifetime
    ... It allows me to have all the actual business logic reside only in the server side code. ... For data access, the presentation layer calls either the business logic component, or calls a data access component directly. ... We don't use the factory pattern, but we will probably move towards it if it looks as though the number of ports open for remote objects is getting unwieldy. ...
    (microsoft.public.dotnet.framework.remoting)