Access Commander Environment - Pre Requisites

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]

• NotePad++
  On both Database Server and Application Server

DNS Entries

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

SSL Certificates

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

SMTP Information

• Host Name
• Port Number
• Outbound User Mailbox account with Credentials (similar to a donoreply account)

Database Server

• SQL Server configured on Static Port instead of Dynamic Port
• SQL Server configured for Mixed Mode Authentication
• SQL Server Reporting Server installed

SQL Server Reporting Server

• 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

Application Server

• 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

Availability of following Port Numbers on Application Server

• 5001
• 5010
• 5020
• 5030
• 5040
• 80 (for CMS Credentials)