For SQL Data Profiler, the queries require access to the system views INFORMATION_SCHEMA.COLUMNS and INFORMATION_SCHEMA.TABLES. For every database that a connected account wants to profile, the account needs permissions granted to access these system views. By default, sysadmin has these permissions. That is, VIEW SERVER STATE permission is required to retrieve Profile results.
To issue grants using a database administrator account with SYSADMIN privileges:
Please also refer to the Microsoft document "GRANT Server Permissions (Transact-SQL)".
You can now download SQL Data Profiler v184.108.40.2060 which checks upon startup whether the proper permissions have been set.
Refer also to the forum post "How to determine the version of an installed free tool?".
Powered by IDERA