login "distributor_admin" for transactional replication

login "distributor_admin" for transactional replication

Post by Wen chan » Thu, 27 Mar 2003 02:13:23

Tring to configure transactional replicaion using
Enterprise Manager , but got
the following err msg after entering all the required data:
"Could not configure "MSDBA01" as the distributor.
Error 18483: Coutld not connect to server "MSDBA01"
because distributor_admin is not defined as a remote login
at the server".    Is this login created by the the
Creating Publisher, Distributor process or it has to be
created by me manually?

login "distributor_admin" for transactional replication

Post by Alvin Zhao[MSF » Sat, 29 Mar 2003 15:14:10


Please try to execute: sp_helpserver and see if you see repl_distributor in
the query result. If so, please remove the repl_distributor server as no
replication is set up.

To remove the repl_distributor, please execute the following SQL statement:

exec sp_dropserver 'repl_distributor', 'droplogins'

After removing repl_distributor, try to set up replication again and see if
it works.


Alvin Zhao
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.


1. Error when configure "Transactional Replication"

Hi All,

I am trying to configure database server with paramters such as below
    Distributor/Publisher : user sa, database : test
    Subcriber : user : abc (dbowner), database : test1
I configure Publisher as Transactional and Queue Update
I configure "type Push Subscriber" to replicate 2 database
But it's OK to update data from Publisher to Subscriber and when
Updating occur in Subcriber it can' t update to Publisher and it has error
as message below :
    Server: SERVER, Database pmw : ODBC Error:Could not change the
    Publisher because the subscription has been dropped. Use
sp_subscription_cleanup to clean up the triggers.

2. Saving a file in a different name

3. transactional replication - how to "Synchronize Now "

4. Merry Christmas comp.databases.filemaker NG!

5. "Replication login"

6. Migrating packages between servers

7. max of ("...","...","..")

8. SQL7.0 SP2 on Windows 2000. Reinstall W2000?

9. What is "Transactional DDL?"

10. DTS "Login Failed"

11. DB Login has impact on "RequestLiveness"

12. "12345" login name

13. "Login Failed" since installing ODBC3.5