What are the challenges you face when working across database platforms? Take the survey

Permissions required to view permissions in 2008

scotteb@mindspring.comscotteb@mindspring.com Posts: 16 Bronze 2
edited August 28, 2008 10:16PM in SQL Compare Previous Versions
I am comparing databases on a 2005 and 2008 server. My login is a member of Public role on the server and I am dbo on the database. When scanning the 2008 database, SQL Compare 7 stops on "Server.Database-Reading Permissions" and the info message at the bottom of the dialog says that "The user does not have permission to perform this action."

What additional permissions do I require?



  • Options
    DennisRehmDennisRehm Posts: 13 Bronze 2
    I am getting the same error comparing two SQL Server 2008 databases. If I connect as a sysadmin, everything is OK. If I connect as a db_owner, I get the Reading permissions error.

    I need to compare to a SS2K8 hosted database where I cannot be a sysadmin.


  • Options
    I received an e-mail from Red Gate support today:

    "We have found that the problem is caused by the compare engine trying to get transparent database encryption information which is only accessible for users with the VIEW SERVER STATE permission on the server.

    A fix will be in the next version will populate the information only if it has permissions, rather than failing outright."
Sign In or Register to comment.