Forum Discussion
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...
Hi ElliotP,
1. Please check if the outbound traffic over port 1433 port is allowed on the machine which has desktop runs.
2. Please add firewall rules to specify which IP address ranges from the Internet are allowed. See: Azure SQL Database server-level and database-level firewall rules.
3. Please enable Telnet Client feature then run telnet command in cmd. See: Windows 7: Enabling Telnet Client.
Best Regards,
Qiuyun Yu
I got this error because I was entering my server name slightly wrong. So, if you do all of the technical stuff and it isn't working...check the exact server name.