Re: Remote Server issue...
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/25/03
- Next message: F_MIkey: "Using DOS batch file to change MSDE blank passwords"
- Previous message: Gary Whitley [MSFT]: "RE: problems with client access from an external IP"
- In reply to: Brett: "Remote Server issue..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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.
- Next message: F_MIkey: "Using DOS batch file to change MSDE blank passwords"
- Previous message: Gary Whitley [MSFT]: "RE: problems with client access from an external IP"
- In reply to: Brett: "Remote Server issue..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
