Installing the Reporting Solution on the MS SQL Server

Quick Start Guide

Install 11.9 on the SQL Server

See Prognosis Installation and Configuration 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

Deploy the SQL Reporting solution

See Prognosis and SQL on Single 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

Provide feedback on this article