Ssrs service unavailable http error 503 the service is unavailable

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 FilesMicrosoft SQL Server Reporting ServicesSSRSLogfiles

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 product 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.

DefaultSetup.ini

To find the product key in your installation media, the PID is contained within the DefaultSetup.ini file located under RootX86 or Rootx64 folder.

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

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

read the rest of this blog post here on windows-noob.com

This entry was posted in 2002, BitLocker Management, Reporting. Bookmark the permalink.

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 FilesMicrosoft SQL Server Reporting ServicesSSRSLogfiles

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 RootX86 or Rootx64 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 ..x64DefaultSetup.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 🙂

The other day, I have powered ON my Configuration Manager lab after long a time to test something on the reporting and found that, the reporting URL does not work.

Browsing the reports URL leads to service unavailable with http error 503, The service unavailable.

I have verified that, the SQL server reporting services is running fine and i have restarted the service as well to check if this works or not but no luck.

I have realized that, there is something seriously wrong and took sometime to troubleshoot further.

The first log to check is srsrp.log (ConfigMgr log) for reporting services located in your configMgr installation directorylogs folder.

The log has the following errors:

The request failed with HTTP status 503: Service Unavailable.

(!) SRS not detected as running

Failures reported during periodic health check by the SRS Server CMserver.domain.name

I have also checked the reporting server configuration manager, everything seems to be fine.

The next is to look at the SQL server reporting services log located in

C:Program FilesMicrosoft SQL Server Reporting ServicesSSRSLogFiles

The log has the following error messages:

configmanager!DefaultDomain!5018!04/04/2021-14:23:28:: e ERROR: Error loading configuration file: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.

appdomainmanager!DefaultDomain!5018!04/04/2021-14:23:28:: e ERROR: Appdomain:1 DefaultDomain failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.  —> Microsoft.ReportingServices.Diagnostics.EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required..

AS you can see in the log, the license has expired for SQL server reporting services.

When you install the SQL server reporting services, you will be asked for the trail of 180 days or input the license key of the SQL server.

If you choose trail, then after 180 days, you will have the same issue like mine.

So now, we found that, the license for the SQL server reporting services is expired, how do we activate it now?

The only way that I could find is to reinstall the reporting services.

Run the SQL server reporting services installation wizard (I did 2019), you will see the following options. Choose upgrade, you will be asked for the key to activate it.

Once the installation is completed, wait for the reporting services to check the license status and rebuild the reports (there wont be any changes your default/custom reports) and after sometime, your reporting URL will be up and running.

hope this helps!