Re: Configuring Distributor

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: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)