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

    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?

    Thanks
    Anagha-NH

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    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
  •