Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unhappy Unanswered: How do I create distributor_admin

    I am trying to a set up a distributor but I keep getting an error "SQL server Enterprise manager could not configure 'MyServer(ServerName)' as distributor for 'MyDB'(database name).

    This what I want to do set up 'MyServer1' as publisher and distributor and 'MyServer2' as subscriber.

    I am using 'Configure Publishing and distribution wizard' to set up publisher & distributor ,and when I finish the wizard I am getting error'distributor_admin' is not defined as remote login at the server, I think the distributor_admin is removed by mistake. How can I resolve this issue?


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    If you have not set up any huge publications, as yet, it should be easy enough to disable replication and start from scratch. SQL 2000 does a much better job of that than SQL 6.5 used to.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts