[AccessD] 365 Access web app connectivity question

[Susan Harkins]

<https://blogs.office.com/2013/01/22/visualize-your-access-2013-web-app-data
-in-excel/>

Apparently, it doesn't take hoops but you do need to know what options to
enable.

Susan H. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Friday, January 6, 2017 11:17 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] 365 Access web app connectivity question

Hi Susan

I'm not familiar with accessing web apps, but the Azure portal is easy to
navigate in - given the enormous variety of services currently offered.

You may need a Virtual Network at Azure:

https://portal.azure.com/#blade/Microsoft_Azure_Marketplace/GalleryFeaturedM
enuItemBlade/selectedMenuItemId/Networking_MP

but I'm just guessing from your description.

/gustav


-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Susan
Harkins
Sendt: 6. januar 2017 16:44
Til: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Emne: [AccessD] 365 Access web app connectivity question

I have an E3 365 subscription, which comes with a SharePoint site. I
currently have a simple Access Web App shared on that site. 

 

I thought I could easily grab data from it using Excel 2016's Get and
Transform feature, but the attempt returns a connection error: Details:
"Microsoft SQL: Cannot open server "ssharkins.onmicrosoft.com" requested by
the login.  The login failed."

 

With just a bit of research I think I'm looking at a connection problem - or
more specifically a firewall setting. It's possible that I need an Azure
Management account, which is free with my sub, I just haven't done it
because I didn't need to. Apparently, I can configure my firewall as needed
using this account. Or, I need to configure the Windows Firewall to allow
the connection locally. In the end, that might not even solve the problem.
Perhaps I can sign in to my 365 account as an admin and flip a switch
somewhere - but I don't know which switch. I looked around but it's a needle
in a haystack for me. Perhaps I need to set a connection in Excel first -
but I haven't been successful doing that either. 

 

I'm no longer running SQL Server, so I don't have that management tool to
work with. 

 

Frankly, I just expected it to work - I didn't expect to have to jump
through any hoops. I have limited networking skills so I don't know what to
do next. I'd rather not waste a lot of time trying to figure that out. 

 

I know most of you aren't using Access Web Apps, but you might be working
with Azure, so I'm hoping someone will have some insight. Thanks for
considering it and I apologize if I'm not asking the right questions. I'm
obviously using the wrong search strings either because all I can find are
SQL Server connection discussions. It's like Excel's Get and Transform
feature doesn't exist within this context. 

 

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com