Dismiss Notice

Register now to be one of the first members of this SharePoint Community! Click here it just takes seconds!

Dismiss Notice
Welcome Guest from Country Flag

How to visualize Access 2013 web app data in Excel

Discussion in 'SharePoint Blogs' started by sriram-varadarajan,, Apr 1, 2017.

  1. sriram-varadarajan,

    sriram-varadarajan, Guest

    Blog Posts:
    0
    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

    [​IMG]

    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.

    Continue reading...
     

Share This Page

LiveZilla Live Chat Software