Issue
When logging in to Web Reports, the "Reports Tree" to the left is not shown, and an error message is shown stating that login has failed for the user "NT AUTHORITY\IUSR".
Product Line
EcoStruxure Building Operation
Environment
Building Operation WebReports
Cause
This is a result of not following the Web Reports installation guide. The SQL Server must be installed with an instance name, and the SQL Server must be started by the user "SYSTEM".
Resolution
There are two solutions to this issue:
- Reinstall the SQL Server and Web Reports following the installation guide
- Use the SBO Reports Agent Config tool on the Community to give access to the 'NT AUTHORITY\IUSR'
Alternatively for a more in-depth answer consult How to Fix Login Failed For User NT AUTHORITY IUSRS to add the user "NT AUTHORITY\IUSR" to the SQL Server