Forum Discussion
Getting error when migrating Power BI report server databases to another host
We are using Power BI report server Jan 2023 version. We are trying to migrate PBI RS databases from host A (sql server 2017 standard) to host B (sql server 2019 standard) . I am following instru...
What edition does the Configuration Manager report when you start it up? My local version is using a developer install, but a production one should say "Power BI Report Server - Enterprise"
If the edition is reported incorrectly you might need to raise a support ticket with Microsoft.
If the edition is correct then does the user doing the migration have SysAdmin rights on the new SQL Server instance. They only need this during the database configuration, but the config tool tries to check SQL Agent and configure roles so it needs these elevated permissions.