Forum Discussion

Karthik12's avatar
Karthik12
Icon for Post Patron rankPost Patron
4 years ago

Connecting power BI with remote My SQL server (XAMPP PhpmyAdmin)

Hello Team,

Our production output server developed in Mysql Xampp PhpMyadmin. It was placed in our company main server.

Everytime, there is an output scanner, Output table will stored in mySQL database (it will referesh every 2 mins). I would like prepare dashboard using power bi. 

I was trying to connect remotely that mysql server but failed. (my laptop not installed any workbench or my sql software). 

I have downloaded .net connecter 8.0.28 and installed. 

Also, in phpmyadmin page, I was given privillege to the particular database with user id and password.

I have tried, but It is looking like connecting almost but It is asking to check whether server allowing remote connection. (erros i have attached below)

 


May I know, in which are options to make the connection? (my sql server data base or SQL server data base?)

How to enable remote connection in phpmyadmin?

 

Note : company server needs my windows user id and password then my sql previllege they have set different user id and password for me. So, in order to access server inside server which are steps I need to follow?

 

Please support guys. I am struggling for 2 weeks.

 

Thanks in advance !!!

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Karthik12 ,

    About this error please learn more about the article.

    provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: 53)

    SQL Server does not exist or access denied".

    This error usually means that the client can't find the SQL Server instance. This issue occurs when at least one of the following problems exists:

    • The name of the computer hosting SQL Server is incorrect.
    • The instance doesn't resolve the correct IP.
    • The TCP port number isn't specified correctly.

     

    You can refer the content in the following links to achieve it:

    How to get data from SQL Server from an external server

    Connect to remote server via VPN

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.