I get the error following error when I try to define the distributor at the publisherLogin failed for user 'distributor_admin'. I could not find a user/login as distributor_admin on my publisher server but its available on the distributer server. I did use a password when i configured distributor at the distributor and used the same at the publisher as well. Note: publisher server is SQL 2000 whereas distribution server is SQL 2005. Please advise
In SQL 2005 the distributor_admin remote server is now a linked server (called repl_distributor) and you can change the password and security context it runs under on the linked server.
