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.
You can now download SQL Data Profiler v18.104.22.1680 which should fix the issue with "Index was out of range." and "VIEW SERVER STATE permission was denied.". This fix is related to the forum post "Required SQL Server permissions".
Refer also to the forum post "How to determine the version of an installed free tool?".
Powered by IDERA