SQL Server Performance

The schema could not be propagated to the subscrib

Discussion in 'Performance Tuning for SQL Server Replication' started by santnair, Oct 13, 2005.

  1. santnair New Member

    Hi ,

    I was tring a merge replication.
    When the subscriber tries for a synchronization.
    I get a error :
    ----------------------------------------------------------------
    The schema script"\servernamec$programfiles.... "could not be propagate to the subscriber
    ----------------------------------------------------------------

    user account of the subscribers have access righhts to the server etc....
    plz provide solution.
    thanks in advance


    Regards
  2. satya Moderator

    The acount must have admin rights on the subscriber and ensure the share is properly declared.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. santnair New Member

    thanks satya,

    Here the subscriber does have admin rights.
    And how you declare the share.The folder is shared for both the subscriber.
    What is this regarding the declaring the share.

    Thanks in advance

    Regards
  4. satya Moderator

    From Windows explorer goto that path and then right-click to create the share and allow proper privileges to the accounts.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. santnair New Member

    Thanks,
    Yess satya, I have done that, I have given all the user account of the subcribers previlages.But still the same error.
    Its a pull replication (Merge)

    Thanks in advance

    Regards
  6. satya Moderator

Share This Page