Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
can not perform sync in onine database? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    i think schema is non-dbo,that will the problem ,

    thanks for your reply.....

    Wednesday, July 23, 2014 4:58 AM