Use the IDERA Reports Utility to deploy reports on your SSRS Instances. This utility is part of the SQL Inventory Manger installer.
Note
IDERA Reports Utility needs to be installed on the same server as the SIM services.
Accessing the report deploy utility
To access the IDERA Report Utility go to the ReportUtility folder inside the SQL Inventory Manager installation path. The default location for the IDERA Reports Utility is C:\Program Files\Idera\SQLInventoryManager\ReportUtility
Deploying reports
To deploy reports on your instances follow these steps:
- Open IDERA Report Utility.
- Type the required information.
- Report Server Web Service URL: The location of the report server.
- Target SQL Server: The server that hosts the SSRS service.
- SQL Database: The name of the target database.
- Login ID: A Windows user ID with Content Management rights on the Report Server.
- Password: A valid password for the previous user ID.
- Click Next.
- Select the reports you want to deploy and click Next.
- Click Finish to close the window.