How does one publish ChangeAuditor searches to SQL Reporting Services (4355007)

How does one publish ChangeAuditor searches to SQL Reporting Services so these searches can be used as SRS Reports?

Some customers may wish to use SQL Reporting Services to run pre-defined searches / reports rather than using the ChangeAuditor Client to do so.

From the ChangeAuditor Client:

• Click "View | Searches" from the File Menu.
• Find the search or make a new search that matches on the criteria that is desired (ensure the search is returning expected results).
• Right-click on this search and choose "Create Report(s) using SQL Reporting Services...
• On the "Create Report" window, click "Configure..."
• On the "Reporting Services Setup" window, ensure the settings are correct for your SRS Server, for example, the "Reporting Server URL:" should be in a format similar to "http://<SQL_SRS_REPORT_SERVER>/ReportServer"
• Ensure the user account is that of an account that is has "Content Creator" rights on your SRS Server so it can publish reports. This account also requires "ChangeAuditor - Operators" rights on the ChangeAuditor database in SQL.
• Press "Test..." to test your settings and also ensure you can access the specified URL: "http://<SQL_SRS_REPORT_SERVER>/ReportServer" outside of ChangeAuditor before actually troubleshooting it as a ChangeAuditor issue, since this should be accessible via Internet Explorer first, outside of ChangeAuditor.

If UAC is enabled on your ChangeAuditor Client computer and you do not run the ChangeAuditor Client as Administrator to bypass UAC, there may be an error similar to: "Client found response content type of "," but expected "text/xml". To fix this, either disable UAC and then reboot your Client computer, or run the ChangeAuditor Client as Administrator to bypass UAC.

================

Microsoft arcticle on "How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008" can be found here: http://support.microsoft.com/kb/938245

Here is an article on how to configure user permission so other users can run SRS reports (for example, by granting users' Browser rigths in SRS): http://msdn.microsoft.com/en-us/library/ms156014.aspx