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]

  • 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)


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article