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

    Question Unanswered: Replication - sp_MSget_subscription_guid impossible

    We currently have a pull transactional subscription running from a remote 'PublicationServer' in another country to our local server.

    After restarting our fire wall we get the following error message:
    "The process could not execute '{call sp_MSget_subscription_guid(16)}' on 'PublicationServer'."

    This message is followed by another error message: "Another distribution agent for the subscription(s) is running.", although nothing was changed to the configuration and no SQL processes were started or restarted.

    When we restart the distribution job manually it runs as if nothing happened.

    Does anyone know what exactly caused the failure, and how to prevent it ?

    Philip
    Last edited by ptobback; 09-01-04 at 10:39.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quit restarting your firewall ???

    I really don't have a good answer for this question. Sometimes after an unexpected failure, the simplest answer is just to manually restart what won't start automagically.

    -PatP

Posting Permissions

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