The Reports setup program installs the SQL Safe Reports application. The Reports Installer utility allows you to specify the proxy user account credentials and select which built-in SQL Safe reports you want to deploy.
When you install the SQL Safe Full version, the SQL Safe Reports utility is installed automatically. Locate the utility in the SQLSafe Reports sub-directory of the main SQL Safe installation directory (e.g. C:\Program Files\IDERA\SQLsafe\SQLSafe Reports).
If you want to install SQL Safe Reports locally, locate the SQL Safe Reports installation file (“Idera SQLsafe Reporting Services.exe”) in the installation directory of the SQL Safe Management Console (e.g. C:\Program Files\IDERA\SQLsafe).
The following procedure guides you through a local installation of Reports. However, you can also deploy Reports remotely.
To install reports:
- Log on with an administrator account to the Report Server computer.
- Copy the “Idera SQLsafe Reporting Services.exe” file onto the server and run it.
- Read the Welcome window, and then click Next.
- Review and accept the license agreement by selecting I accept the terms in the license agreement, and then click Next.
- Accept the default folder for your Reports installation, or click Change to specify a different folder, and then click Next.
- Click Install. When the installation is completed, the Idera SQL Safe Reports Installer window will appear.
- On the IDERA SQL Safe Reports Installer window, specify the following configuration settings, and then click Next.
- Report Server Web Service URL: URL for the SQL Server Reporting Service.
- Target SQL Server: SQL Server instance hosting the SQL Safe repository database.
- SQL Database: Name of the SQL Safe repository database.
- Login ID and Passwords: Credentials of the Windows account the Report Server should use to connect to the repository database. The specified account should have read permissions on this database.
- Select which SQL Safe reports you want to deploy to this Report Server, then click Next.
- Click Install.