I downloaded version 220.127.116.110 and tried it on a SQL 2012 instance. It connects to the instance and database fine, but when I pick a table, I get 2 messages. The first says:
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.
The second box says:
The user does not have permission to perform this action
I get the same error on all tables. My login is the dbo for the database I'm using.
The queries that gather information for this tool require access to INFORMATION_SCHEMA.COLUMNS and INFORMATION_SCHEMA.TABLES. The connected account needs permissions granted to these SYSTEM VIEWS for every database they want to profile.
I checked and the login has access to both of these system views.
Please provide a Log File for further analysis. See http://community.idera.com/free-tool-forums/f/forum/23175/kb-how-to-send-log-files-for-free-tools-to-idera.
Just sent the application log as well as an event log warning.
User has view definition permission and is a member of the db_owner role. I was able to run the above query in SSMS without any problems.
I was able to reproduce this issue by REVOKING VIEW DEFINITION and GRANTING VIEW DEFINITION for a test account. Note: When performing these actions you must restart the application and retry the Profile action. Ignore the Index out of range message, that is a red herring. I've put in a request to have that fixed. Other than that, I don't know what else to tell you but it is definitely a permission related problem. Note, DB_OWNER role by itself is not sufficient since that only Grants VIEW ANY DATABASE. Why the query is working in SSMS I don't have an answer for. See if you can try an account that is in the SYSADMIN role if you can.