SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting service 2017 error, and SSRS service is not shown up in the SQL server configuration...


Reporting service 2017 error, and SSRS service is not shown up in the SQL server configuration manager

Author
Message
sqlfriends
sqlfriends
SSC-Forever
SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)

Group: General Forum Members
Points: 43532 Visits: 4676
I did an in-place upgrade for a SQL server 2014 to 2017.

The server has both databases and reporting services.

I run from the installation files then it tells to download reporting service first and then install the new SSRS service. then it uninstall the old service from the wizard and upgraded the database engine.

After that I get into reporting service manager to reconfigure the site and database and restore the encryption key.

Then I go to the web portal http://myservername/reports, I got an error:
Service unavailable , HTTP Error 503. The service is unavailable.

I restarted the service from configuration manager of reporting service, it does not help.

What could be wrong?
Also I don't see SSRS services shows up in the SQL Server Configuration Manager (it shows in reporting server configuration manager), there only shows SQL server and Sql server agent services, are these supposed to be in SQL server 2017?
It is so different with previous version of SSRS, so not sure if this is correct?

Also I don't see the scale out deployment tab in reporting server configuration manager, I installed the standard edition.
So no that feature, but in previous version it still shows the tab, is that supposed to be not shown this tab in standard edition of SSRS?
Thanks,
sqlfriends
sqlfriends
SSC-Forever
SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)

Group: General Forum Members
Points: 43532 Visits: 4676
I found somehow the upgrade process add MSSQLServer to the keytable.

I deleted that record and just leave SSRS item key there. Now I can access the web portal and also reporting server service.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search