Web Reports - Installation

Matthew Fifield -

  1. Verify VDM is installed and setup correctly, setup instructions here.

  2. Verify IIS is installed and setup correctly, setup instructions here.

  3. Verify Microsoft SQL Express 2014 is installed and setup correctly, setup instructions here.

  4. Extract the files from the WebReportsDeploy.zip.  The zip can be downloaded here.

  5. Open the IIS manager. Expand down to the desired website.  Right click on the desired website, select "Deploy" and then "Import Application".



  6. Browse to and select the WebReports.Zip in the extracted WebReportsDeploy folder. Click Next.



  7. Use the default Selected Content from the package.



  8. Use the default Connection String information. Click Next.  **IMPORTANT**If the SQL server is not local, or the Instance is not SQLExpress, these connection strings will need to be modified to the correct server/instance.  For the third connection string (WebReportsEntities) it is vital to not use the connection wizard (...).  This connection string will need to be modified manually by ONLY replacing the following section: data source=localhost\SQLExpress;initial catalog=WebReports;integrated security=True.



  9. The wizard will automatically install WebReports and apply the permissions to the SQL Database.



  10. Verify that the installation was successful.



  11. Edit the WebReports Permissions.  Give the IIS_IUSRS group permission to Write.  To do this right click on WebReports and edit Permissions.

    EditPermissions.png

    Permissions.png

  12. Optional (Recommended). Create the event source for WebReports to write to the Windows Event log.  Run the following command via Windows PowerShell (as administrator):
    [system.Diagnostics.EventLog]::CreateEventSource("Web Reports", "Application")

  13. Browse to the website/WebReports (the first launch will take some time as it's setting up the SQL database with the default roles/Administrator.

  14. Set paths for important WebReports options.
    1. Temp Data Output: This is the location where any temp data for views will be stored.
    2. Temp Data Duration (minutes): This tells WebReports how long temp data will be available until it is deleted.
    3. Log Files: This is the location of VDM's logs.  Web Reports will write to the same log files.
    4. Executable: This is the actual executable that will be used for WebReports.  This can be changed from the 32-bit executable or the 64-bit executable.
    5. Reports: This is the location where any views that will be used for WebReports are stored.
    6. Profiles: This is the location of the connection profiles that will be used.
    7. Application Options: This is the location of VDM's options file.
    8. Account Lockout Duration: This is the duration an account is locked out after any number of attempts.
    9. Account Lockout Attempts: This is how many failed login attempts before the account is locked.
    10. IP Lockout Duration: This is the duration an IP is locked out after any number of failed attempts.
    11. IP Lockout Attempts: This is how many failed login attempts (does not look at specific accounts) before the IP is locked.
    12. Email Profile: This is the location of an Email profile from VDM.  This email profile will be responsible for forgotten passwords and email confirmations.
    13. Enable SSO: This option enables the Single Sign On option.  When enabled, WebReports will look for the SSO Header (next option).  If the header exists, WebReports will then check the value of this header (username) and match it to the User that is setup in WebReports, bypassing the login (if the user exists and has access to the report).
    14. SSO Header: This is the exact header that WebReports will look for if SSO is enabled. This header will need to contain the user id.
    15. Show Register Button: This option hides the registration button.
      Options.png

  15. Login as Administrator with the Default Password of "A@Z200711".



  16. Change the Password for the Administrator Account by managing the account (click Hello Administrator).



  17. Instructions on managing Web Reports can be found here.
Have more questions? Submit a request

Comments

Powered by Zendesk