Install the reporting database
The reporting database allows you to use the data synchronized from your production database to build reports for your facility. You can use any reporting tool to extract the information from the reporting database and create your reports.
Before you begin
About this task
- Example:
- sp_configure 'max text repl size', 2147483647
For information on setting up database replication, visit the Microsoft Developer Network website and review the article, SQL ServerReplication.
Procedure
- From the application splash screen, click Install Reporting Database.Note: If this splash screen does not appear, run SetupReporting.exe on the root directory of the installation folders.The License Agreement page appears.
- Review the license agreement, and then click I Agree.The Installation Folder page appears.
- Accept the default destination folder or browse for a new location, and then click Next.
- In the Configure Reporting SQL Server area, enter the following information, and then click Next.
- In the Configure SQL Server area, perform one of the following actions:
- Leave the Use a local SQL database with Windows Authentication check box selected, and then click Next.
-
Clear the Use a local SQL database with Windows Authentication check box, enter the following information, and then click Next.
- In the SQL field, enter the name of the SQL Server where the SQL database is located.
- In the Database field, enter the name of the production (SQL) database that you will connect to for synchronization.
- From the Authentication list, select the type of authentication you want to use. If you choose to use integrated security, select Windows Authentication; otherwise, select SQL Server Authentication, and then enter the user name and password for the SQL Server.
- In the Workflow Server Configuration area, enter the following information, and then click Next.
- In the Server computer name field, enter the fully qualified name of the server computer.
- In the Configure Security area, enter an administrator user name and password.Important:
- You cannot use a Windows user name and password to configure security for the reporting database; it must be a valid Windows administrator user name and password.
- The Advanced user authentication settings (Use SSO, Allow Password Change, Enforce User Lockout, and Enforce Password Complex Rules) do not apply when installing the reporting database.
- Click Install.
- When the installation is complete, click Exit.