[AccessD] 365 Access web app connectivity question

[Susan Harkins]

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.