Red Gate forums :: View topic - sql data compare permission error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

sql data compare permission error

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
ronald



Joined: 04 Aug 2011
Posts: 2

PostPosted: Thu Aug 04, 2011 5:26 pm    Post subject: sql data compare permission error Reply with quote

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
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Aug 04, 2011 6:20 pm    Post subject: Reply with quote

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/Content?c=knowledgebase%5CSQL_Data_Compare%5CKB200802000227.htm&p=SQL%20Data%20Compare

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
ronald



Joined: 04 Aug 2011
Posts: 2

PostPosted: Thu Aug 04, 2011 6:48 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Aug 04, 2011 6:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group