This looks great, but I have an issue.
Firstly, I have imported and enabled the classes.mof information, and edited the configuration.mof file. If I look at Resource Explorer for a particular device, I can see “SQL 2008 Property” and elements underneath that. I also restarted the sms executive, and the SQL Server Reporting Services service. I also downloaded SW-SQL_Server_Products and imported it on the Reporting Services server to my Asset Intelligence folder. I then edited the datasource via Report Builder to point to the {5C6358F2-xxx..} connection on my site server.
When I open the report, I can select a collection (say All Systems) and when I press “View”, I get the following:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSetSQLVersions’. (rsErrorExecutingCommand)
The SELECT permission was denied on the object ‘v_GS_SQL_Legacy_Property0’, database ‘CM_EG1’, schema ‘dbo’.
Is there a step I am missing?