Fixing an evaluation version of SSRS with "HTTP Error 503. The Service is unavailable"

[anyweb]

Introduction

I was writing a blog post about Troubleshooting BitLocker Management in ConfigMgr 2002 Current Branch and one of the things I was trying to do was install the web portals, but I was seeing errors shown below.

Get-ReportServiceUri : Caught exception querying report service at http://cm01.windowsnoob.lab.local/Reportserver

I assumed this was because SSRS was not installed or configured but after checking the lab, I could see it was indeed installed and configured. However when I browsed the http://cm01.windowsnoob.lab.local/ReportServer URL in Internet Explorer it produced a  HTTP Error 503. The Service is unavailable.

A quick search gave some clues and things to try but in reality the reason it was not working was because:

• SSRS was installed in evaluation mode
• SSRS evaluation had expired

This was revealed in the logs stored at C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\Logfiles

To upgrade the evaluation version you'd normally just need to upgrade the edition of SSRS from Evaluation to Production via change/uninstall in Control Panel, however the way this installation was packaged (WIX bundle) meant that it retained the original download link in a bundled file called state.rsm

and that was looking in the IE cache as you can see in the SSRS installation log files

That path no longer existed. Manually recreating that path and copying the SQLServerReportingServices.exe file to that path did not help, it reported another error.

I could keep trying to hack my way around these errors or fix it once and for all.

Fixing the evaluation version

As this is just a lab I decided to rip SSRS out completely and then add it back.

Note: If you are doing this in production then make sure to backup all your custom reports first and if necessary backup the reporting databases also.

I decided to try the following:

• uninstall reporting from ConfigMgr
• delete the 2 reporting db's in SQL
• uninstall SQL Reporting Services in control panel
• restart server
• reinstall SSRS
• reconfigure SSRS

Keep in mind that unless you want the same problem occurring in 180 days or so, you'll need the key that was used when installing SQL. If this process doesn't pick it up from your installed instance of SQL, you can find that key in the installation media.

Using the product key from DefaultSetup.ini

To find the product key in your installation media, you should know that the PID is more than likely contained within the DefaultSetup.ini file located under Root\X86 or Root\x64 folder. Open that file with notepad and copy the product key for later use.

 

Let's get started. In ConfigMgr remove the SSRS role.

Confirm that it's removed successfully via the SRSRPSetup.log.

Next, in Sql Server Management studio, find the 2 reporting services databases and remove them, if you are doing this in Production, read my NOTE at the top of this section as deleting the two Reporting databases will result in the following: Reporting services will not work (it's broken already...), all your reports will have been lost (you did back them up didn't you ?), schedules, permissions, etc.

And now they are gone.

Next in Control Panel, locate SQL Server Reporting Services and uninstall it.

Once uninstalled, close the wizard.

restart the ConfigMgr server.

 

After the server has restarted, reinstall SSRS by launching SQLServerReportingServices.exe available for download here for SQL Server 2017 or here for SQL Server 2019. After downloading it, copy it to a safe location outside of the browsers cache, eg: C:\SSRSSource.

Run the executable and choose Install Reporting Services.

Paste in your SQL License key from the SQL Server media, look in ..\x64\DefaultSetup.ini and your SQL license key will be in there.

Accept the license terms

Install the database engine.

Pick the path and click next, after a while it's completed. Click on Configure Report Server.

Select Connect when prompted. The report server configuration manager wizard will appear, notice how it states the version is Standard (and not evaluation).

 

In Web Service URL, click Apply.

Note: This is assuming you want to configure SSRS in HTTP mode, if you'd like to use HTTPS mode please review this blog post.

For Database, choose Change Database.

Choose create a new report server database from the options

Decide if you are going to use the current logged on user or a SQL server account to setup this new database

Select the database name.

continue through that wizard until completion. Make sure it's all successful before clicking on Finish.

Next, click on Web Portal, and choose Apply.

And you can configure other options or simply select Exit.

In the ConfigMgr console, add back the reporting services role

Configure the account...

And confirm that it was successfully installed in the SRSPSetup.log.

At this point you can go back into your web browser and confirm that reporting is indeed responding without the initial error.

Tada !

and via the Reports web portal.

And finally, verify that the reports are present and working in the ConfigMgr console

And that's it ! Once again I started one blog post only to hit an issue that threw me a wobbler. But thanks to that you have this blog post 🙂

 

 

 

[Md. Ehteshamuddin Khan]

Dear Companion   

My issue has been resolved once I followed the steps, it is really helpful the way of elaboration.

Once again thanks.

Regards

[ssnbokhari]

Just wanted to say thank you, we ran into the same exact issue and its resolved through these steps!

[helpme]

Hello, is there a way to do this without deleting the DB's? can we uninstall reporting services and re-install then reconnect to the DB's which are located on a remote SQL always on cluster? Do i need to worry about the encryption key if i do this?

[GarthMJ]

1 hour ago, helpme said:

Hello, is there a way to do this without deleting the DB's? can we uninstall reporting services and re-install then reconnect to the DB's which are located on a remote SQL always on cluster? Do i need to worry about the encryption key if i do this?

Unless you have any custom reports that you don't have backup for. I would deleted the Db and start over.