Forum Discussion
SQL Connection Named Pipes Provider, error:40
Evening,
I'm still having the same issues as before in my previous thread that I thought I had solved. I've done a little troubleshooting and I'm not sure where to go. When I attempt to run queries into tables in my pbix I receive the error "SQL Connection Named Pipes Provider, error:40" on one of the random tables all hosted in the same database.
Here is the error: https://gyazo.com/03f703d0260b43bda59f8e32dcdb4bfe
Following this guide: https://azure.microsoft.com/en-au/blog/sql-azure-connectivity-troubleshooting-guide/
I've created an opening in my windows firewall to 1433. When I run the telnet on the port, I receive this: https://gyazo.com/8b2c4c06df9be90eeeae02ad2dad9afb
When i follow the steps and attempt to ping my azure sql server's ip, I recieve this output:
https://gyazo.com/82f1fc01d0c7f0da433ad8a737a7d9be
Thoughts on a solution? I have tried running queries into tables on a vm and it bounced for an unknown reason. I sent a frown so I'm hoping to hear back.
13 Replies
Hi ElliotP,
1. Please check if you can connect to the Azure SQL database via SSMS. Make sure the Server name and Database name are correct.
2. Verify the IP address of the machine which has Power BI desktop run on. Please create a IP range in Azure SQL which contains that machine IP to allow the connection. See: Azure SQL Database server-level and database-level firewall rules.
Best Regards,
Qiuyun Yuv-qiuyu-msftThanks for the response.
I have done both and the issue still persists. I have a static IP address as well.
