I recently deployed some of the Idera reports in SSRS, using the ‘deploy reports’ option from within Idera. It successfully deployed the reports and the datasource, and connected the reports to the datasource. When I run the reports, the server dropdown list has no servers listed–I dug into the report a bit and found the procedure (p_GetReportServers) that is supposed to return the list does not return any values. Is there some configuration value that I’m missing or a fix for that procedure?
Do you have application security enabled within SQL Diagnostic Manager? If so, you’ll want to be sure that the connection you’re using for reporting has at least read rights to the servers in question. Does that make sense?
I have verified that the account used by SSRS has access to the database and has the role granted that provides execute permissions for the stored procedure.
I manually executed the stored procedure myself on the Idera repository server database and also got no rows returned.
But the reports do work in-product?
Yes, I executed the report from within Idera first to verify the content and ensure that is the information I want to present via SSRS before I deployed the report from Idera to SSRS.
OK, just to rule things out, under the Administration tab at the bottom left of DM…. Application Security, is the Application Security feature enabled at all?
Powered by IDERA