SQL Server Performance

Login failed for user 'distributor_admin'.

Discussion in 'Getting Started' started by sunil, Aug 24, 2007.

  1. sunil New Member

    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
  2. satya Moderator

    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.
  3. sunil New Member

    thanks its working now

Share This Page