Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shubuya
Frequent Visitor

Upgrading existing SSRS to PBIRS, Web Portal Error: "The service is not available."

I've spent hours researching this and to no avail. We've upgraded SQL Server 2016 to 2017 and detached the ReportServer db as part of this process. After installing SSRS v14.0.6514.11481 and pointing to the restored ReportServer db it worked perfectly.

 

The problem came when we tried to upgrade to PBIRS. Recieved this message when navigating to the localserver/Reports portal:

 

Capture.PNG

 

Checked the logs and it said:

ERROR: Database downgrade detected. The database schema version is newer than service schema version.

 

Not sure how to proceed here. Why would the db schemas be incompatible?

 

Trying to complete this process for reference:

https://docs.microsoft.com/en-us/power-bi/report-server/migrate-report-server

 

9 REPLIES 9
avknishokpbi
Frequent Visitor

Hi,

 

yes I know, it's my own blog, which I also linked to in my previous reply 😉

 

Regards,
Koen

Blog: sqlkover.com
v-yulgu-msft
Employee
Employee

Hi @shubuya,

 

Did you install both SSRS instance and Power BI Report Server on your machine? If so, did you use a single ReportServer DB for both SSRS and PBI report server?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Yes I installed both SSRS and PBIRS, and yes we are using a single ReportServer DB.

Hi @shubuya,

 

You should create two separate reportserver databases for SSRS and PBIRS.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft, I cloned the ReportServer database created with SSRS and pointed PBIRS to it. Shouldn't that work?

 

I have the same issue. Were you able to solve it?

My SSRS native databases come from SQL Server 2017 CU4.

I restored them on a new instance, where the Power BI Report Server is installed. This is the latest version (14.0.600.442).

 

The web service works (so the server can connect to the database), but the portal won't work, giving the error provided in this thread.

Blog: sqlkover.com

I ended up contacting a Microsoft tech and through hours of troubleshooting found that I should not have connected to a different edition of SSRS before connecting Power BI Report Server. See response below:

 

The ReportServer that is being migrated has likely been connected to a different edition of SSRS. Power BI Report Server cannot connect to a ReportServer database that has been upgraded from SSRS 2016 to SSRS 2017, as the database schemas are not compatible. Scale-out deployment is also not possible using both SSRS and PBIRS

 

This may not be your issue, but it was for me. I think the ambiguous error messages made this difficult to realize for a novice like me.

I finally solved the issue and it was indeed because the databases are not compatible. I blogged about the solution here: http://sqlkover.com/migrate-ssrs-2017-to-power-bi-report-server/. In short: there's some table with an incorrect build number and the database schema isn't supported.

 

Personnally, I find the explanation of the Microsoft employee lacking. The documentation states it's possible to upgrade from SSRS 2012 and later to Power BI Report Server. In my case even, it was from a straight SSRS 2017 installation (so I did not upgrade from SSRS 2016 to 2017).

Blog: sqlkover.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.