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, 

     

    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
      Most Valuable Professional
      9 years ago

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

      • 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.