Configure Microsoft Internet Information Services (IIS)

Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

 

Article Goal: Configure IIS.

 

In this article we are going to provide the steps to configure your server in IIS.

 

Steps To Configure IIS.

 

1. Launch Internet Information Services (IIS) Manager.

 

 

2. Expand the drop down and right click on Application Pools, then select Add Application Pool.

 

 

3. Enter an Application Pool Name. In the example below we used WebReports.

 

 

4. Set the .NET CLR version to No Managed Code, then click OK.

 

 

5. Expand the Sites folder, then select Default Web Site or create a new site.

 

OPTIONAL: Enable Windows Authentication and disable Anonymous Authentication 

 

6. Select Basic Settings under the Edit Site section.

 

7. Click Select for the Application Pool.

 

 

8. Select your new application pool, then click OK.

 

 

9. Click OK on the Edit Site form.

 

 

10. Click on Application Pools. Right click on the new application pool that you created, then select Recycling.

 

 

11. Uncheck the Regular Time Intervals option, then click Next.

 

 

 

12. Click Finish.

 

 

13. Right click on the new application pool you created again, then select Advanced Settings.

 

 

14. Change Start Mode to AlwaysRunning.

 

 

15. Change Idle Time-out (minutes) to 0.

 

 

16. Change Idle Time-out Action to Suspend, then click OK.

 

 

17. Click on the Default Web Site, or create a New Site (reference IIS documentation for more information on creating a new site) then click Bindings.

 

 

18. Click Add.

 

 

19. Change the Type to https.

 

 

20. Select your IP address.

 

 

21. Enter your port. (Default port is 443)

 

22. Enter the DNS name of your server and select your SSL certificate, then click OK.

 

Note: If you do not have one, contact your certificate authority (CA).

 

 

23. Select port 80, then click Remove.

 

 

24. Select Yes.

 

 

25. Download and extract the files from the WebReportsInstall folder. See note below prior to extracting.

 

IMPORTANT NOTE: Unblock the files in the WebReportsInstall zip before extracting

 

 

26. Wait for the files to finish extracting.

 

 

27. Copy all of the contents in the WebReportsInstall folder. (Ctrl + A > Ctrl + C)

 

 

28. Paste them into your wwwroot folder. (Refer to step 6 : Physical Path for file location)

 

 

29. Open your appsettings.json file with a text editor.

 

 

30. Edit the appsettings.json connection string for the DefaultConnection with the following information.

IMPORTANT NOTE: / \ { } ; are not permitted in SQL passwords as they conflict with the appsettings.json file strucutre.

 

Using Microsoft SQL Server

- Make sure the Microsoft SQL default connection is not commented out ( // ) and that the MySQL connection is.
- Server (Found at step 2 - Configure Your Microsoft SQL Server Instance In SSMS)
- Instance Name (Found at step 7 - Microsoft SQL Express 2019 SSMS Installation)
- Database (Found at step 9 - Configure Your Microsoft SQL Server Instance In SSMS)
- User ID (Found at step 11 - Configure Your Microsoft SQL Server Instance In SSMS)
- Password (Found at step 13 - Configure Your Microsoft SQL Server Instance In SSMS)
- Set the database type to MSSQL

 

 

Using MySQL

- Make sure the MySQL default connection is not commented out ( // ) and that the Microsoft SQL connection is.
- Server (Name / IP address of the server hosting MySQL)
- Port (Set at step 8 - Installing MySQL)
- Database (Set the name of your WebReports database here - Default can just use WebReports)
- User ID (Set at step 11 - Installing MySQL)
- Password (Set at step 11 - Installing MySQL)
- Set the connect timeout to 60.
- IMPORTANT: Pooling set to false (this is for MDS support on MySQL connections)
- Set the database type to MYSQL

 

 

 

31. Edit the appsettings.json with your registration information.

- LicenseKey
- CompanyID

 

 

 

32. Replace YOURVALUEHERE with a new WRXValue (What is WRXValue?) and enter your company ID. We recommend using a generator for the WRXValue.

IMPORTANT NOTE: / \ { } ; are not permitted as they conflict with the appsettings.json file structure.

 

 

For Windows Authentication: Set Authentication to "Windows" and set the Domain / Username for the account currently logged in.

 

33. Verify the EncryptedConnection setting is set to false if you are not using encrypted connections. If you are using encrypted connections, set the EncryptedConnection option to True once you have set up your encrypted connection string.

 

If not using encrypted connections: EncryptedConnection set to FALSE

 

If using encrypted connections: EncryptedConnection set to TRUE

 

34. Select the Default Web Site and then click on the Browse Website link.

 

 

35. Sign into WebReports using the default admin login. If you are using Windows Authentication, you will not see the login page and will be taken directly to the registration page. See step 36 for registering WebReports.

 

IMPORTANT NOTE: Immediately change the default Administrator password after logging in.

 

Username: Administrator

Password: WebReports@0001

 

Note: A self signed certificate was used for the demo purpose, resulting in the "not secure" connection.

 

 

36. Enter your registration information which is included in the PDF you received with license information (same info used during VDM installation and registration). The ID section will self-populate after the registration is complete.

 

Note: If you do not have the license information just reach out to support@bridgeworksllc.com and we can assist you with retrieving the information.