Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Exclamation Unanswered: Server not found in the DistributionPublishers collection.

    I have transactional replication setup between two Win
    2000 (SQL Server 2000) boxes. Everything was working fine,
    but all of sudden I've been getting the following error
    message -
    "[SQL-DMO]The name 'MYPROD01' was not found in the
    DistributionPublishers collection. If the name is a
    qualified name, use [] to separate various parts of the
    name, and try again."
    I dont know what to do to rectify this,
    Please let me know if anybody has a suggestion.
    thanks,
    Vic.

  2. #2
    Join Date
    Dec 2002
    Posts
    2
    I found out that it was working for a login that had SQL Server System Admin priviliges, and was not working for a loging that did not have System Admin priviliges.

Posting Permissions

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