Forum Discussion

steveearle86's avatar
steveearle86
New Member
5 years ago

On-Premise Report Server - Powershell to update Connection String

Hi There, I have an on-premise PowerBI Report Server and have backed up and restored the production database to a test server. I want to update the connection strings on the test server so the data ...
On-Premise
PowerShell
ReportServer
gsprague's avatar
gsprague
Microsoft Employee
5 years ago

Hi steveearle86 , A few things:

  1. Can you tell me what version of ReportServer you are using? Our current release is Power BI Report Server January 2021 - info here: Jan2021 Release Notes . If you are not on Jan 2021 can you first upgrade to this version?
  2. After upgrading to Jan2021 release, can you enbale verbose logging and try the series of actions again? Information can be found here: PBIRS Enable Verbose Logging 
  3. Finally, it is by design that you will need to supply credentials for the new connection, even if they happen to be the same username/password.
steveearle86's avatar
steveearle86
New Member
5 years ago

Hi,

Thanks for your response. We are on version Version 1.9.7604.41261 (October 2020) at present. We have plans to upgrade to January 2021 but ironically, would like to solve this first if possible as it enables us to create a test environment.

 

As for your third point, that makes sense (and I thought that might be the case) I can allow for that in my script, however I need to understand why the refresh does not work after a manual update of the credentials first.

 

I have enabled the verbose log for our server, where does information get logged to?

  • gsprague's avatar
    gsprague
    Microsoft Employee
    5 years ago

    For the January 2021 release, the verbose logging contains additional information in the logs for diagnosing scheduled refresh errors.  In the same release we also fixed some scheduled refresh errors.