Initialize-RS for Power BI Report Server

[petrparik]

Do you want to request a feature or report a bug? bug

What is the current behavior? Initialize-RS throws an error: "Get-WmiObject : User credentials cannot be used for local connections"

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem. Install Power BI Report Server (but not configure it via GUI) Use this PowerShell to initialize:

Connect-RsReportServer -ComputerName $env:COMPUTERNAME -Credential $installCredential
Set-RsDatabase -DatabaseServerName "JC-SQL-01\LAB" -IsRemoteDatabaseServer -ReportServerInstance PBIRS -DatabaseCredentialType Windows -DatabaseCredential $databaseCredential -ReportServerVersion SQLServervNext -Name ReportServer -AdminDatabaseCredentialType Windows -AdminDatabaseCredential $installCredential
Set-PbiRsUrlReservation -ReportServerVersion SQLServervNext -ReportServerInstance PBIRS 
Initialize-Rs 

I also tried Initialize-Rs with parameters (comp. name, credentials, ...) - throws the same error.

What is the expected behavior? Initalize-Rs does not throw errors.

Which versions of Powershell and which OS are affected by this issue? Did this work in previous versions of our scripts? PBIRS is installed on Windows Server 2016. I'm running the script locally on that computer. The database backend is on a remote named instance.

Initialization of DB and reservation of URL works as expected. Initialize-Rs throws the mentioned error.

[jtarquino]

Are you running it locally in the server? We do use it all the time in the CI pipeline

[petrparik]

@jtarquino yes

[petrparik]

@jtarquino When I run the command exactly as you have it in the CI pipeline

Initialize-Rs -ReportServerInstance PBIRS -ReportServerVersion SQLServervNext

then I get this error: Failed to Initialize Report Server, ErrorCode: -2146233088

I get this error for any combination of parameters except when I specify credentials. When I add -Credential parameter (with domain admin account), I get "User credentials cannot be used for local connections".

I'm most likely doing something wrong :)

Though the initialization command is not successful, the portal seems to be accessible and working after rebooting the machine.

[jtarquino]

I would check in the logs C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles but unfortunately those initialization steps are not that easy to diagnose. I don't remember if that command would fail if you run it more than once in a server already initialized

[petrparik]

I found lots of these errors:

library!DefaultDomain!e3c!05/03/2019-16:06:59:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

[jtarquino]

Those indicate that the database has not configured before the initialization, for example in the CI

[petrparik]

But the Set-RsDatabase worked well. No error. And the two databases were created on the remote server. After I restart the computer, the portal works well, I can create folders etc.

Or am I missing some other command? Is it necessary to call something else except these?

• Connect-RsReportServer
• Set-RsDatabase
• Set-PbiRsUrlReservation
• Initialize-Rs (this one does not work for me)

[petrparik]

Guys, please I need to automatize the installation and configuration of PBIRS. I cannot make it working. Today I tried to install and configure remotely from a client machine. It works the same way - everything succeeded except Initialize-Rs. Hitherto shall I come, but not farther. Again the same error: Failed to Initialize Report Server, ErrorCode: -2146233088

Please help, what can be wrong? Thanks a lot, Petr

[ktodd1]

I was getting same error on Initialize-Rs. Did a stop and start PowerBIReportServer Service after Set-PbiRsUrlReservation and prior to running Intialize-Rs. Then it worked.