Thanks for making these forums available. I searched for my error here, and permissions was my problem for my version 5.3 Data Compare.
Somehow the view permissions got dropped for our developer group on the database in question, and once our DBA set them correctly again, the Compare worked fine.
notec
Posts: 2
Comments
Our apologies for not getting back to you sooner...
Normally this issue is caused by the login you are using for the comparison not having sufficient permissions in the database(s), as explained here:
http://www.red-gate.com/messageboard/vi ... php?t=3999
It's a somewhat obscure error, so doesn't really give much of a hint as to what it might be.
Do you think you would be able to try it with a user which has dbo rights and see if that works?
Somehow the view permissions got dropped for our developer group on the database in question, and once our DBA set them correctly again, the Compare worked fine.