Forum Discussion
Named Pipes Error 40
Super User
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.
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!