Comments
3 comments
-
do I need to clarify what I mean or raise it via a support ticket?
I guess redgate staff view these forums looking at the other forum posts - surely someone can tell me what permissions I need to run red gate data generator?
Thanks,
Terry -
ahh, just received the automated 'this has been raised as a support incident' email - very good support! Looking forward to the answer
-
Hi, thanks for posting. We do respond to unanswered forum posts- they get auto-logged as tickets after a day or two. The idea of the forums is more for "inter-user-discussion", and if you have an urgent enquiry it's usually best to email support@red-gate.com directly so you get a faster response.
Anyway, in answer to your query, it's cropped up before and the article relating to SQL Compare Permissions helped - see here
The bit that may be causing it is if you're on SQL 2008; you may need the "View Server State" permission as described in that article. This is so that our tools can work with encrypted objects in your database.
Hope that helps!
Add comment
Please sign in to leave a comment.
My user account is in db_owner for the DB I want to create data for, and I have no problem using our SQL Compare and SQL data compare against the same DB, but when I run Data Generator it says:
"Create Project
- Reading permissions
The user does not have permission to perform this action"
I'm definitely using the same account as I do with Compare/DCompare - is db_owner not enough for SQL Data Generator?
If so, what specific roles do I need to perform this task?
I've attempted on local instance databases (where I have pretty much everything that sa has) and that works a treat, though our infrastructure team will be very reluctant to grant that level of access to a developer (and to be honest, the power would go to my head! lol)
Help
Many thanks,
Terry
Tombola Ltd