Issue
The Web Server threw an exception.
Please make sure the StruxurewareReportingAgent service is running and is set to run "Automatic"
An error occurred on the Web Server while processing your request. If the problem persists, please contact your system administrator.
Environment
Webreport 1.4 upgrade
Cause
A WebReports installer must use an admin-level SQL Server Management Studio user account to log on to a computer running WebReports. This installer account also requires the addition of three database permissions that permit access to and control of the WebReports database during installs or upgrades. For example, an administrator can detach the database.
In SQL Server Management Studio, verify that the Login Properties for the NTAuthority\IUSR and designated WebReports installer user accounts include the db_datareader, db_datawriter, and db_owner database role memberships.
Resolution
Use SQL management SQL studio and log in to the SQL.
Use properties on the user NTAuthority\IUSR and make sure the following are included
db_datareader, db_datawriter, and db_owner database role memberships.
