Issue setting up Replication

• El barto

  Ten Centuries

  Points: 1072

  More actions

  October 6, 2006 at 5:45 am

  #91873

  Hi,

  I have begun to setup Replication on a SQL 2000 server. I have created the distributor_admin account, however when I proceed to the replication Wizard i get the following error message :-

   

  "Error 18456 : Login Failed for user distributor_admin'.

  Have you seen this error previously?

   

  Thanks.

  ---

  Kindest Regards,

  Nick

• October 9, 2006 at 8:00 am

  This was removed by the editor as SPAM

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  October 12, 2006 at 2:06 am

  #665399

  you say you've set up the account ? Replication does this for you. remove the account and try again.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/