Getting an Error 1001 near the end of the SmartStruxure WebReports Installation
Reports not functional from WebReports
SQL 2008 R2
Windows Server 2008
Windows Server 2012
This error is caused when the WebReports installer is unable to reach SQL Server Reporting Services to configure the WebReports Interface
- Clean of the Pieces of the failed install. Use the uninstall process listed in the WebReports Reference Guide or Lessons Learned 12316
- Correct all possible causes of the failed install
- Verify that you can connect to the ES using http from the Reports Server PC
- Verify that you can connect to http://localhost/Reports_SQLInstanceName
- Re-install WebReports.
NOTE: You may be able to correct the issue without having to remove and re-install WebReports.
Possible Issue: The Microsoft Reporting Service SQL databases are not registered
Check through SQL Management Studio that the 2 databases "ReportServer$instance" and "ReportServer$instanceTempDB" are registered. If not, the SBO Web Reports installed have nowhere to place the report pack files.
If they are not there, you need to add them through "Reporting Services Configuration Manager". Click "Database" and then "Change Database". Here you can chose to create new databases.
Possible Issue: Insufficient User Access
- Log out of Windows and Log back in using a PC admin account. The account logged in for the install should have full access to windows and be a Db admin in the SQL Server.
- Set the User Account Control Settings to Never notify.
Possible Issue: PC Configured as a Domain Server
- In the Server manager check that the IIS Role is configured and that there are no Domain Roles assigned to this PC
Possible Issue: Another Application is using a Required SQL function
- Uninstall any application which use SQL on this PC. (The Enterprise Server does not Use SQL)
- As a Best Practice, the Reports Server should be installed on it's own, dedicated PC.
Possible Issue: Incorrect Version of SQL Server or Windows Server
- Check the Reports Server Specification Sheet for your build and verify that you are on the Correct Version of Windows and SQL.
Possible Issue: Secure Connection Level set too high
- This issue typically also results in not being able to log into http://localhost/Reports_SQLExpress.
- Log into the Reporting Agent Configuration Manager Application
Click on the Report Manager URL on the left hand column
- Click on the http URL
- This will give you the correct URL for your installation of SQL
- If this fails, browse to C:\ProgramFiles\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\ReportServer (this may vary based on SQL Installation)
Modify the CONFIG file "rsreportserver"
Change the Secure ConnectionLevel to "0"
- Save the file and attempt to log into http://localhost/Reports_SQLExpress again.
- For more details on this property see: http://technet.microsoft.com/en-us/library/aa179559(v=sql.80).aspx
Possible Issue: .NET Framework is not operating correctly.
- Download the correct version of .NET framework for you version of StruxureWare. (SBO 1.4.1 and earlier must use .NET 4.0 and 1.5.0 and newer must use .NET 4.5)
- Run the installer in "Repair" mode
Possible Isser: The Windows account "appuser" is not created because the default password does not meet password policy requirements
- Temporarily disable password policy on the server and try reinstalling