Forum Discussion

mpesara's avatar
mpesara
Helper I
8 years ago
Solved

Power BI report server configuration issue

Trying to configure report server to use database engine form sql server 2017 express and eval .

Throws the following error

"The Database engine instance you selected is not valid for this edition of report server"

 

Tried installing on different machines with windows 10 and windows server 12 R2 . used sql 2017 express , 2016 express , and 2017 evaluation.

Using power bi premium key to install the report server. 

Worked on one VM with windows 10 and sql 2017 express . The setup setup did not work in three other machines.

The test connection works in all the cases.

 

 

Thanks in advance.

  • mgmeyer's avatar
    mgmeyer
    8 years ago

    If your using a Power BI Premium Key to install your report server you can only connect to paid SKUs of SQL Server DB which would be Standard and above; express, developer and eval are not supported.

16 Replies

  • mgmeyer's avatar
    mgmeyer
    Power BI Team
    8 years ago

    If your using a Power BI Premium Key to install your report server you can only connect to paid SKUs of SQL Server DB which would be Standard and above; express, developer and eval are not supported.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Ah okay, this is for me new - thanks. So you can try to install the eval from the PBI RS to install.

    • mpesara's avatar
      mpesara
      Helper I
      8 years ago

      yes, it worked without the license key! Thanks for all the help!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    You must use a SQL Server standard edition or higher. The report server needs a SQL Server agent,  and a express doesn't has this feature.  On a Report Server without Power Bi is an deployment on a express edition possible. The documentation in on this point not very clear and helpful. 

    • mpesara's avatar
      mpesara
      Helper I
      8 years ago

      I installed standered edition eval to test and developer editon as well, both has SQL server agent , up and running  . But i still get the same error

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Are you really sure that you connect with the configuration manager against the developer/standard edition?