Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Named Pipes Error 40

I have a somewhat unique situation and I'm having trouble finding an answer anywhere online.   So I have two servers, both Windows servers 2016. One soley a MySQL server, the other a web server.  ...
error message
Installation
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago
Anonymous wrote:

So I have two servers, both Windows servers 2016. One soley a MySQL server, the other a web server.

 

I am attempting to set up power bi report server on my web server, when I do this I get the part where I'm attempting to connect to my database. It then gives me an error that it can't connect:

Are you getting this error while running the Report Server Configuration? Power BI Report Server needs an MSSQL database in which to store its configuration data. Once that is configured you can then build reports against any other supported data source you like.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the reply, Correct, I am still setting up the configuration.

     

    I was not aware that power bi required MSSQL, I was under the impression that with the connectors it could just use MySQL. So if I set up MSSQL on my SQL server I can use that for the configuration, and then have it connect to the MySQL database for the source. got it, thank you!