How can we help you today? How can we help you today?

sql data compare permission error

I got reading DDL error when using sql data comapre at registering database stage. The sql account already have db_owner role in the database. What other permission it need to resolve the issue?

Thanks
ronald
0

Comments

3 comments

Sort by
  • peter.peart
    Thanks for your post. The below article on our support site details the minimum permissions required for SQL Data Compare:

    http://www.red-gate.com/supportcenter/C ... %20Compare

    HTH!

    Pete
    peter.peart
    0
  • ronald
    Peter,
    thank you for your reply. I have seen the article before, and added dbo_owner to the sql account. But still have the error At "Registering database - xx -Reading DDL triggers." "The user does not have permission to prerform theis action." The database is backup/restore from another server. I am using Red Gates Defaults for the options tab.
    Any further idea?
    ronald
    0
  • peter.peart
    What about VIEW DEFINITION and being a member of the PUBLIC role?

    Your best bet is to try viewing DDL triggers through SSMS with that account; if you can't do it there, you aren't going to be able to do it with SQL Data Compare I'm afraid and it comes down to it being a SQL Server permissions issue that you will need to resolve with your DBA and SQL Server Books Online.

    The article I linked to previously though contains full details of all permissions required, so if you believe you've followed the instructions to the letter, as I said try looking at it in SSMS. If it is then working in SSMS but not SQL Data Compare, by all means let me know.

    HTH!

    Pete
    peter.peart
    0

Add comment

Please sign in to leave a comment.