Forum Discussion

RVK's avatar
RVK
Frequent Visitor
4 years ago
Solved

Issue while migrating Power BI server database to AWS RDS

HI All, We are facing issues when trying to migrate the power bi report server database which we have  on the standalone SQL server instance to a AWS RDS. We were able to restore the database to RDS...
AWS RDS
Migration
Power BI Report Server
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    I'm not sure if RDS is supported as a backend for Report Server so it will be interesting to see if this works for you. To configure the back end database I believe the person running the configuration tool needs to have sysadmin rights. This is because a new application role needs to be created in MSDB and the PBIRS service account needs to be added to some of the SQL Agent operator roles so that it can create SQL Agent jobs in order to trigger scheduled reports and refreshes. Once the configuration has been done you can remove the sysadmin rights from that person. 

d_gosbell's avatar
d_gosbell
Super User
4 years ago

I'm not sure if RDS is supported as a backend for Report Server so it will be interesting to see if this works for you. To configure the back end database I believe the person running the configuration tool needs to have sysadmin rights. This is because a new application role needs to be created in MSDB and the PBIRS service account needs to be added to some of the SQL Agent operator roles so that it can create SQL Agent jobs in order to trigger scheduled reports and refreshes. Once the configuration has been done you can remove the sysadmin rights from that person. 

RVK's avatar
RVK
Frequent Visitor
4 years ago

Thank you very much. I really doubt if AWS would allow sysadmin rights atleast for a second ðŸ˜€. 

Not sure on how to take this forward.