Error installing Power BI Server

Hmm can we try to create yet another database?

Yes, I can. Whne we create a new database we have to provide credentials twice. What these credentials are?

Hi Markzolotoy,

You can find more info about how to config Power BI Report Server in the help docs:

- https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database

- https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-native-mode-report-server-database

I ahve created a new database for the third time, did not have any errors. Still:

The service is not available.

The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key.

Learn more

I deleted the keys, did not get any error. Still:

The service is not available.

The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key.

Learn more

Is it possible to trouble shoot this error?

Hi, I run into same problem, please provide more details about solution. Thank you

I had to change the service account o Network Service.

Like : Reporting Services Configuration Manager / Service Account / Use built-in account: Network Services ? I tried this and still same error. Thank you

It still mignt a problem with accessing the report server database. Check if you can access it with creadentials you are using.

I'm admin. What else can be ? Thank you

danm can you provide a little more info on your configuration as well as the specific error you are seeing, is it the service not available error? Specifically:

- Do you have multiple versions of Reporting Services installed (i.e. SSRS 2016, SSRS 2017, PBIRS)?

- What account are you using for the PBIRS service account?

- If you have multiple installs of SSRS did you use the default DB name?

- Are you trying to reuse and existing DB from as a previous install or did you create a new catalog?

Solved as suggested by mgmeyer here: http://community.powerbi.com/t5/Report-Server/PowerBi-server-and-Sql-server-reporting-services-2016-on-same/m-p/208124#M244

Solution: uninstall sql server reporting services 0.1.6214.16719

Hi, mgmeyer

     What happen if I have mutltiple versions of SSRS installed in the server

     I have some issues to install the PBIRS in those servers that already had previous SSSRS version (2012) installed.  The error message is showing there is some issue to install SQLSysClrTypes.msi but failed.  

[3E5C:26B4][2018-03-30T10:31:52]i301: Applying execute package: SQLSysClrTypes.msi, action: Install, path: C:\ProgramData\Package Cache\{AC92C896-149B-4254-80CF-D1FC8BF4E831}v14.0.3015.40\SQLSysClrTypes.msi, arguments: ' MSIFASTINSTALL="7"'
[3E5C:26B4][2018-03-30T10:31:52]e000: Error 0x80070643: Failed to install MSI package.
[3E5C:26B4][2018-03-30T10:31:52]e000: Error 0x80070643: Failed to execute MSI package.
[24C4:2780][2018-03-30T10:31:52]e000: Error 0x80070643: Failed to configure per-machine MSI package.
[24C4:2780][2018-03-30T10:31:52]i000: Setup: Install Completed for package Microsoft System CLR Types for SQL Server 2017
[24C4:2780][2018-03-30T10:31:52]i319: Applied execute package: SQLSysClrTypes.msi, result: 0x80070643, restart: None
[24C4:2780][2018-03-30T10:31:52]e000: Error 0x80070643: Failed to execute MSI package.
[3E5C:26B4][2018-03-30T10:31:52]i329: Removed package dependency provider: {AC92C896-149B-4254-80CF-D1FC8BF4E831}, package: SQLSysClrTypes.msi

Thanks, 

RL