server, Remote Server and Replication

When trying to create a Linked Server using MS Sql Server 2000 (8.00.818), I
encounter a SQL Server error stating:
Error 15028: The Server Darq111 already exits.
The Darq111 server does NOT appear as a Linked Server but does appear as a
Remote Server.
On the 30 or so remote Sql Servers that I have previosly pushed
subscriptions to, I never had any problems with Linked Servers--maybe because
the Linked Servers were created prior to the push subscription? On the 3 new
remote Sql Servers that I recently pushed subscriptions to, I did not set up
a Linked Server first. Perhaps this is the problem?
I am hoping that someone can help me understand what I need to change in
order to setup the Linked Server properly. The final goal here is to be able
to query a remote Sql Sever from my host site... such as:
select * from server31.db.dbo.customer, etc.
Any help would be greatly appreciated.
what happens when you issue a select * from
RemoteServerName.dbo.master.sysobjects.
You may need to issue a sp_serveroption 'RemoteServerName', 'Data Access' to
enable this
"Jason Duncan" <Jason Duncan@.discussions.microsoft.com> wrote in message
news:C1913F32-A999-4916-9DC4-5ECEFA4A605F@.microsoft.com...
> When trying to create a Linked Server using MS Sql Server 2000 (8.00.818),
> I
> encounter a SQL Server error stating:
> Error 15028: The Server Darq111 already exits.
> The Darq111 server does NOT appear as a Linked Server but does appear as a
> Remote Server.
> On the 30 or so remote Sql Servers that I have previosly pushed
> subscriptions to, I never had any problems with Linked Servers--maybe
> because
> the Linked Servers were created prior to the push subscription? On the 3
> new
> remote Sql Servers that I recently pushed subscriptions to, I did not set
> up
> a Linked Server first. Perhaps this is the problem?
> I am hoping that someone can help me understand what I need to change in
> order to setup the Linked Server properly. The final goal here is to be
> able
> to query a remote Sql Sever from my host site... such as:
> select * from server31.db.dbo.customer, etc.
> Any help would be greatly appreciated.
|||Thanks Hilary!
That fixed it. On my Host Sql Server, I ran:
sp_serveroption 'DARQ111', 'Data Access', 'TRUE'
"Hilary Cotter" wrote:

> what happens when you issue a select * from
> RemoteServerName.dbo.master.sysobjects.
> You may need to issue a sp_serveroption 'RemoteServerName', 'Data Access' to
> enable this
> "Jason Duncan" <Jason Duncan@.discussions.microsoft.com> wrote in message
> news:C1913F32-A999-4916-9DC4-5ECEFA4A605F@.microsoft.com...
>
>