Access Commander Environment - Pre Requisites

Modified on Tue, Jun 6, 2023 at 2:30 PM

The customer is responsible for everything listed here.
MathCraft will not be assisting nor performing any of the pre-requisites below.

Text Editor Application [Required]

Need 4 A records created pointing to the same App Server

Access Commander application
This will be the URL that will be used by end users to access the application
Sample A record: accesscomm.company.com
Dashboard
Sample A record: accesscomm-dashboard.company.com
Adhoc Reporting
Sample A record: accesscomm-reporting.company.com
CMS Credentials
Sample A record: accesscomm-credentials.company.com

Will need either a wildcard certificate (*.company.com) OR 3 separate SSL Certificates based on DNS A Records (CMS Credentials does not need one).

Create a non-RDP user account as ssrs-admin and a password
Google Chrome or Microsoft Edge (Chromium) browser installed on the Database Server (temporary - you can delete after the configuration is completed)
Configuration of SQL Server Reporting Server Configuration Manager

Oracle Java Runtime (JRE) 8 installed
SQL Server Connection Information
SMTP Information for E-Mail Services
SSL Certificate(s) installed in IIS for URL Bindings
IIS Configured to have the following Web Server features [No Exceptions]
Common HTTP Features
Default Document
Directory Browsing
HTTP Errors
Static Content
HTTP Redirection
Health and Diagnostics
HTTP Logging
Custom Logging
Logging Tools
ODBC Logging
Request Monitor
Tracing
Performance
Static Content Compression
Dynamic Content Compression
Security
Request Filtering
IP and Domain Restrictions
URL Authorization
Application Development
.NET Extensibility 3.5
.NET Extensibility 4.7
Application Initialization
ASP
ASP.NET 3.5
ASP.NET 4.7
CGI
ISAPI Extensions
ISAPI Filters
URL Rewrite IIS Module installed [Download here] [No Exception]
Application Request Routing IIS Module installed [Download here] [No Exception]
Ensure the Application Request Routing proxy is enabled