Forum Discussion

ElliotP's avatar
ElliotP
Post Prodigy
9 years ago
Solved

SQL Connection Named Pipes Provider, error:40

Morning,   In the past few days I've been having this issue more and more wherein I'm sometimes able to connect to my sql server when I refresh or apply my queries. In the past I was able to work a...
Need Help
Tutorial Requests
ElliotP's avatar
ElliotP
Post Prodigy
9 years ago

Evening,

 

I added the port 1433 to my windows firewall (TCP port).

 

I would reccomend reading the Accepted Solution's linked guide; it's incredibly useful.

 

 

ElliotP's avatar
ElliotP
Post Prodigy
9 years ago

Evening,


The is presenting itself exactly as the same as before. I can confirm I have added port 1433 in my windows firewall as both an outbound and inbound rule.

 

v-qiuyu-msftI followed your guide and enabled telnet.

 

I follow this guide https://azure.microsoft.com/en-au/blog/sql-azure-connectivity-troubleshooting-guide/ and my telnet what the guide said was successful.

 

I ran a tracert as it suggested and here are the results;

 

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Elliot Parker>tracert 191.239.192.109

Tracing route to 191.239.192.109 over a maximum of 30 hops

  1    <1 ms    <1 ms    <1 ms  NB604N.Home [192.168.1.1]
  2    57 ms    48 ms    47 ms  10.20.23.251
  3    55 ms    57 ms    62 ms  203-213-56-193.tpgi.com.au [203.213.56.193]
  4    56 ms    61 ms    62 ms  cbr-apt-mar-crt2-ge-2-0-0.tpgi.com.au [203.219.1
06.109]
  5    63 ms    61 ms    63 ms  syd-gls-har-crt2-te-0-0-0-3.tpgi.com.au [203.219
.106.117]
  6    48 ms    70 ms    59 ms  syd-sot-ken-crt2-he-0-3-0-0.tpgi.com.au [202.7.1
62.78]
  7    69 ms    73 ms    75 ms  203-219-35-132.static.tpgi.com.au [203.219.35.13
2]
  8    69 ms    65 ms    66 ms  202.7.171.78
  9    76 ms    73 ms    65 ms  ae16-0.mel01-96cbe-1b.ntwk.msn.net [198.206.164.
96]
 10     *        *        *     Request timed out.
 11     *        *        *     Request timed out.
 12     *        *        *     Request timed out.

Any help would be greatly appreciated. I've been stucking simply trying to apply queries to my data for the past 5 days.

  • aghonaim's avatar
    aghonaim
    Most Valuable Professional
    9 years ago

    Thanks ElliotP for your reply. I actually have no control over my windows firewall ports (for technical security reasons). Is there anything that can be done at the Azure side to allow the connection ?!

    • ElliotP's avatar
      ElliotP
      Post Prodigy
      9 years ago

      Morning aghonaim. My best suggestion is perhaps setup a VM running an operating system that will support powerbi and run it off there; I've considered doing it myself as this is beyond irritating. I've been sitting for days waiting for it to run through (I'm limited by my bandwidth and to a certain degree my computer power).

       

      v-qiuyu-msftPlease save me lols