[AccessD] 365 Access web app connectivity question

[Gustav Brock]

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/GalleryFeaturedMenuItemBlade/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.