Menu
Previously I used to be able to access external data from an http:// URL using only Basic Authentication (Username / Password) as text file from within an Excel (2003 version) on a Windows XP Professional laptop.
I recently bought a new Windows 8 laptop, running Excel 2010 and now I can't get access to the same external data. Apparently Basic Authentication for WebDAV on Windows 8 is not by default enabled.
Searching the internet I only find solutions to enable Basic Authentication for WebDAV for windows version older than Windows 8.
Who has a "simple" solution to resolve this? Note that I'm not a developer, just a user.
336
In Control Panel, click Programs and Features, and then click Turn Windows features on or off. Expand Internet Information Services, expand World Wide Web Services, expand Security, and then select Basic Authentication. Click OK. Click Close.
In the Web Server (IIS) pane, scroll to the Role Services section, and then click Add Role Services. On the Select Role Services page of the Add Role Services Wizard, select Basic Authentication, and then click Next. On the Confirm Installation Selections page, click Install. On the Results page, click Close.
WebDAV is a protocol that lets you upload and download data or code files. A merchant sends WebDAV requests to your instance's WebDAV server. The merchant's WebDAV client can be a Business Manager user or an API client for machine-to-machine interaction.
Microsoft has created a new WebDAV extension module that has been completely rewritten for Windows Server 2008 and Windows Server 2012.
Ran into the same issue. Found a solution here, even though the article is for Windows 7. It works the same.
http://www.yeehawup.com/2011/07/mapping-a-network-drive-to-webdav-share-in-windows-7/
The relevant information from the blog post (which I'm shocked is still up after four years) is to set the registry DWORD
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\
Parameters\BasicAuthLevel
to 2.
165
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
