distributor_admin problem when configuring replication 18483
pw_at_indii.com
Date: 02/14/05
- Next message: pUmkInhEd: "Re: identity management..."
- Previous message: John: "Disabling replication on existing databases"
- Next in thread: Hilary Cotter: "Re: distributor_admin problem when configuring replication 18483"
- Reply: Hilary Cotter: "Re: distributor_admin problem when configuring replication 18483"
- Messages sorted by: [ date ] [ thread ]
Date: 14 Feb 2005 08:18:28 -0800
I have read many of the postings on the 18483 error, but I must be
missing something because I can't get it to work and I have been trying
for days. I have also read about this topic in BOL which says the same
thing as the postings.
Local replication has been working for almost a year, but I ran into
problems when I wanted to add a remote site to the process. I
therefore decided to disable replication and reenable it to both sites.
I decided to get it working properly to the local server and felt that
I could then setup it up for the remote.
The problem that I am having is the old 'Error 18483
'distributor_admin' is not setup for remote access. I don't understand
why I am receiving this error since I just disabled replication and
immediately tried to reenable it. (NOTE: I have changed the alias
names for easier recognition since the original setup, although I still
point to the ip addesses of the boxes both local and remote.) I have
since read a posting which suggest to alias to the computer name which
I have done.
BOL says that I need to add 'distributor_admin' as a remote login even
though the publisher and the distributor are the same box. I have run
the 'sp_addremotelogin' stored procedure with several permutations i.e.
Local and Remote user 'distributor_admin', Local user
'distributor_admin' Remote user an admin account on the server and vice
versa. If I use 'distributor_admin' as both the Local and Remote user
I still received the 18483 error. When I used 'distributor_admin' as
Local and an admin account for remote, I receive an error that I am
using the wrong password. I know the password of the admin account
because it is mine. I have also set the 'distributor_admin' account
password to match mine via the 'sp_changedistributor_password' stored
procedure. The same happens if 'distributor_admin' is remote and an
admin account is local.
Does anyone have an idea of what I am missing?
- Next message: pUmkInhEd: "Re: identity management..."
- Previous message: John: "Disabling replication on existing databases"
- Next in thread: Hilary Cotter: "Re: distributor_admin problem when configuring replication 18483"
- Reply: Hilary Cotter: "Re: distributor_admin problem when configuring replication 18483"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|