Installing the Reporting Solution on a Dedicated Server

Install the Management Server

See Prognosis Installation and Configuration for details

Prepare the Management Server to communicate with the SQL Server

See Prepare the Reporting Server for details

Setup the SQL Server

See SQL Server Connection Configuration for details

Check SQL Server Permissions

See SQL Server Permissions Required for Reporting for details

Create the Datamart and Staging databases granting db_owner to the Setup User for both databases

See Creating SQL Server Databases for SQL Reporting for details

Prepare the SSIS Server for the ETL Process

See Prepare SSIS Server for details

Deploy the SQL Reporting solution

See Prognosis and SQL on Multiple Server Deployment for details

Verify that the database deployment is working correctly

See Verify That Data is Stored in the SQL Server Database for details

Deploy the SQL Reports

See Install the SQL Reports on the SSRS Server for details