Forum Discussion

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost 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
Icon for Post Prodigy rankPost Prodigy
9 years ago

Evening, 

 

Thank you so much for the quick response. I added the port and it seems to be running a lot more comfortably; thank you so much.

aghonaim's avatar
aghonaim
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

So where did you add the ports exactly ? and what ports # ?

  • ElliotP's avatar
    ElliotP
    Icon for Post Prodigy rankPost 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
      Icon for Post Prodigy rankPost 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
        Icon for Most Valuable Professional rankMost 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 ?!