Assumption: All pre-requisites have been met.
The following steps are to be done directly on the Application Environment Operating System
CMS Cred Configuration
- Launch IIS Manager
- Under Sites, right click on Default Web Site and click the Add Application option.
- Enter CMSCred for the Alias and set the CMSCred Physical Path to the location where Application was deployed during Step 3.
- Click OK to save the changes.
- Under Sites, right click on Default Web Site and click the Edit Bindings option.
- Click on Add
- Ensure the Type is http and enter CMS Credentials DNS entry requested in the Pre-Requisite for the Host Name. The Port Number should be 80.
- Click OK to save the changes.
Adhoc Reporting Configuration
- Navigate to the Images folder located in Configuration\AdhocReporting\SSRS\Images directory of where the application was deployed during Step 3.
- Replace logo01.png and logo02.png by overwriting the image files
Note: If your logo doesn't meet the specifications above, then we cannot support how the logo displays on your report. - Navigate back to the AdhocReporting folder
- Right click on the SSRS folder and select Properties
- Navigate to the Security tab
- Click the Edit button
- Click the Add button
- Type Everyone in Enter the object names to select field and click the Check Names button
- Click the OK button to save the change
- Select the checkbox to Allow Full Control
- Click OK to save the changes
- Click OK to save the changes and exit out
- Launch IIS Manager.
- Right click on Sites and select Add Website.
- Enter the Site Name as AccessCommanderAdhocReporting.
- Set the Physical Path to C:\inetpub\AccessCommander-AdhocReporting.
- Change the Binding Type to https.
- Enter the Host Name as the Adhoc Reporting host name that was needed as part of the Pre-Requisite.
- Select your SSL Certificate.
- Uncheck the Start Website Immediately box and click OK.
- Under Sites, right click on AccessCommanderAdhocReporting and click the Add Application option
- Enter SSRS for the Alias and set the Adhoc Reporting Physical Path to the location where Application was deployed during Step 3.
Example: C:\AccessCommander\Configuration\AdhocReporting\SSRS - Click OK to save the changes
- Under Sites, right click on AccessCommanderAdhocReporting and click the Edit Bindings option
- Click on Add
- Ensure the Type is https and enter Adhoc Reporting DNS entry requested in the Pre-Requisite for the Host Name.
- Select your SSL Certificate.
- Click OK to save the changes.
- Navigate to Application Pools
- Right click on DefaultAppPool and select Advanced Settings
- Set Enable 32-Bit Applications to True
- Start the AccessCommanderAdhocReporting Site in IIS
Data Source Configuration
- Navigate to the Adhoc Reporting URL (DNS Entry) set earlier in the configuration
- Login to the Adhoc Reporting Portal as Administrator
If you (the customer) requests for credentials, you will need to sign a Waiver of receiving no further support from MathCraft related to the Dashboard - Navigate to the Admin tab
- Select the Add Database Connection option from the left navigation panel
- Enter the following under the Add New Database Connection section
Connection String: Data Source= EnterDBServerName,EnterDBServerPortNumber;Initial Catalog=ACCMDRWEB;Integrated Security=False;User Id=ac_cms_user;Password=FCx$58kqTFKjVD643q;MultipleActiveResultSets=True
Note: Replace the highlighted content with your actual Database Server Name and Port
Number as you did during application configuration
Provider Name: SQLClient
Connection Name: AC - Click the Test Connection button to verify connection
If Connection is successful, you will get a SUCCESS message
If Connection is unsuccessful, you will get a INVALID message - Click the Add Connection button to add the connection
You will get a message about Data Source creation being successful - Navigate to the Data Model tab.
- Click on New button.
- Select AC from the options that appear.
- Click OK to continue.
- Click Add Tables button.
- Type RPT. in the search bar.
- Start checking all the boxes for RPT. view names.
- Click OK to continue.
- Click the Save As button.
- Enter AC for Data Model Description
Enter AC for Data Model File Name
Select AC.xml from the Data Model List - Click OK to continue.
- When prompted, confirm to overwrite the changes.
- Logout from the Adhoc Reporting Portal.