Re: Configuring Distributor

Check to ensure there is a linked server called repl_distributor and it uses
the security context of distributor_admin

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"mrdj" <mrdj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D77607EC-1CA2-4D9E-8822-F4DCAA1D4976@xxxxxxxxxxxxxxxx
It is a fresh install. Add a linked serer to what? could you send me the
details of adding the linked sever I am completely lost.

"Hilary Cotter" wrote:

Is this SQL 2005? And is it part of an upgrade? SQL Server 2000 used a
remote server called repl_distributor which uses the distributor admin
account. In SQL Server 2005 this has been replaced by a linked server. In
some cases I have seen the upgrade of a replication topology with a
remote
distributor does not work successfully.

In my cases I had to add the linked server and password manually, IIRC.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"mrdj" <mrdj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A3B17D13-3D6F-4B84-970A-F8FDDCB16144@xxxxxxxxxxxxxxxx
I keep getting the error message:

An error occurred during decryption.
There is no remote user 'distributor_admin' mapped to local user
'(null)'
from the remote server 'repl_distributor'.
Changed database context to 'master'. (Microsoft SQL Server, Error:
15466)

I have tried a local server account (as BOL describes), I have tried
using
my own SQL account (that has sa priviliges of course), I have even
tried
the
domain account that runs SQL Agent service (despite the note right
there
on
the screen that recommends not to!). I get this error at the end of
all
the
steps whether I try to create a new publication or if I try to
configure
the
publisher.

ANY help would be appreciated!!





.

Relevant Pages

  • Re: merge Replication across Internet
    ... Looking for a SQL Server replication book? ... >> Using a VPN is not essential. ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: merge Replication across Internet
    ... Looking for a SQL Server replication book? ... >> Using a VPN is not essential. ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)