Cant change Power BI Reporting DB ?

[J4CKO]

Hi, I am a SQL DBA who is fairly new to the Power BI admin side of things.

I have been asked to change an existing deployment, to move the SQL Workload off one server to another.

Currently Server A Hosts the Power BI Reporting, the databases for this are on Server B, these are the databases I need to move to server C.

However when I try to move the databases and re point the database via the Database/Change Database/Choose an Existing  Report Server Database functionality, it says. 

"This Edition of Reporting Services requires that you use local SQL Server realtional databases"

Thing is, this happens with either the name of the new server (C) or the existing one (B) which is already in and working so its already using a server that is not local, I can see connections to it ? So it must have been accepted at some point. Both servers can be succesfully connecto using the "Test Connection". 

Another thing that seems unusual, and may be related, on the front page, under Report Server Status it has an instance ID of "PBIRS", and the next item down is the edition which is blank.

Any ideas, suggestions gratefully received. 

[J4CKO · Accepted solution]

Guys, thanks for the replies, looks like it was some kind of corruption or other issue since the laast upgrade, a colleague put the latest update on and it has started working, this one,

https://www.microsoft.com/en-us/download/details.aspx?id=9b521bad-be95-4d23-8ba9-1f38cc7ec59a

I think d_gosbell was right about it not being able to detect the edition, as now its showing in the Config Manager, and will let me past the point where I need to put the new db details.

Thanks again !

The 

[d_gosbell]

So the post by Lucien is correct for SQL Server Reporting Services. But it is not correct for Power BI Report Server since it ONLY has Enterprise or Developer editions, it is not available as part of SQL Express. I think the issue is happening because the configuration tool cannot detect the edition. This is not the expected behaviour, I think you should raise a support ticket with Microsoft so that you can get a support engineer engaged to help figure out why the edition is not being detected correctly.

[v-luwang-msft]

Hi @J4CKO ，

According to the error message.
When using SQL Express, the data source should be local SQL DB.
With SQL Enterprise, Standard, BI versions, you can create data solutions hosted on other servers.

You can refer to the similar solution below.

The feature: "The edition of Reporting Services that you are using requires that you use local SQL S...

Similar error refer:

https://www.azurecurve.co.uk/2019/09/ssrs-requires-that-you-use-local-sql-server-relational-database... 

https://community.spiceworks.com/topic/1285492-sql-express-problem-with-ssrs-when-using-an-expressio... 

Best Regards

Lucien