sql data compare permission error

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

sql data compare permission error

Postby ronald » Thu Aug 04, 2011 5:26 pm

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
 
Posts: 2
Joined: Thu Aug 04, 2011 5:20 pm

Postby peter.peart » Thu Aug 04, 2011 6:20 pm

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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby ronald » Thu Aug 04, 2011 6:48 pm

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
 
Posts: 2
Joined: Thu Aug 04, 2011 5:20 pm

Postby peter.peart » Thu Aug 04, 2011 6:55 pm

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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests