Issue Description: The expectation is to consume the Access Web App data inside excel to get some report out of it. But, this may not work for everyone as it needs some network configuration in place to consume this data.
When you try connecting to from Excel, you might end up seeing this error
One of the reason for this might be port 1433 being blocked by firewall.
Resolution:
We could open the Access Web app in the Access client and set “From Any Location” under the connection properties. Once we do that, we could create the connection successfully and get the data.
Additionally, another error may likely be the result of port 1433 being blocked by a firewall rule.
To check this, you can do the following:
1. Open and Administrative command prompt.
2. Type the following:
C:\> ping <myserver>.database.windows.net
3. You would receive 4 “Request timed out” messages.
4. At the end of these messages, you would see that your server name resolved to an IP address.
5. We need this IP address for the next step
6. Now type the following to see if there are any firewalls/routers blocking traffic to port 1433.
C:\>telnet <IP Address> 1433
If Telnet is successful, the window will change to a completely blank screen. If it fails, you will see an error saying it is unable to connect.
Leave a comment