locked
can not perform sync in onine database? RRS feed

  • Question

  • i tried sync framework in local network ,but i tried that in an online database i can not set provision to the local client database,error that  occur is " The current operation could not be completed because the database is not provisioned for sync or you not have permissions to the sync configuration table ".is it lack of sql permissions?if it is,what permissions are needed to perform sync?
    Tuesday, July 22, 2014 5:14 AM

Answers

  • the error above occurs during synchronization, not during provisioning.

    are you sure you're provisioning before you sync? have you checked if the Sync Fx objects are actually provisioned in the database?

    you might want to check as well on which schema were the objects created (dbo?), if you have a non-dbo schema, you have to specify set ObjectSchema in code

    • Marked as answer by Asish T D Wednesday, July 23, 2014 8:06 AM
    Wednesday, July 23, 2014 1:29 AM

All replies

  • the error above occurs during synchronization, not during provisioning.

    are you sure you're provisioning before you sync? have you checked if the Sync Fx objects are actually provisioned in the database?

    you might want to check as well on which schema were the objects created (dbo?), if you have a non-dbo schema, you have to specify set ObjectSchema in code

    • Marked as answer by Asish T D Wednesday, July 23, 2014 8:06 AM
    Wednesday, July 23, 2014 1:29 AM
  • i think schema is non-dbo,that will the problem ,

    thanks for your reply.....

    Wednesday, July 23, 2014 4:58 AM