Drive Mapping from SharePoint to Windows Server

In my day job I have the unenviable task of looking after our connection to a SharePoint server. I say unenviable because if there’s one thing that is going to go wrong this connection or something to do with it is what will fail. We don’t run the SharePoint service it’s provided by one of our customers and hosted in the cloud. Pretty much all we have to do is download some files and upload a few others. Sounds like it should be an easy job yeah? Anyone who has worked with the SharePoint web interface will know it’s a painful experience to move a lot of files around so to make it easier we map a network drive to the share.

For some reason I’ve never quite got to the bottom of this drive mapping has never been an easy experience. Part of the problem is that our customer uses a customised log in system rather than the standard system offered by Microsoft. This complicates providing a username and password but it’s not the end of the world, it means you have to log into SharePoint in IE before you can map the drive.

The problem I faced today was that no matter what I tried I couldn’t get the drive to map. I was at a command prompt and entering a net use command and every time it was giving me either a “system error 67” or “system error 53” followed by “the network name cannot be found”. I could ping the server so it clearly wasn’t a problem with network connection and IE didn’t have a problem showing me the web view of SharePoint.

The only other thing that was suspicious was that if I tried to view a SharePoint folder in Windows Explorer using the “All Documents > View in File Explorer” link it would briefly open a small IE window and then nothing would happen after it closed. I tried checking the console in IE but there were no error messages. My hunch was that it was something to do with the ActiveX that launches Windows Explorer and that turned out to be right.

The Solution

After entirely too much googling I’d draw a complete blank so I decided to go back to basics. By a stroke of luck I decided to start by looking into WebDAV as that’s how SharePoint transfers files (at least that’s my understanding anyway). The first page I read was this one detailing how to install WebDAV client on Windows Server 2016. I didn’t hold out much hope but it looked like a safe feature to install anyway so why not give it a go.

To my deep joy after installation and a restart the drive would finally make. The “network name cannot be found” nonsense was a complete red herring, the whole system used to make the connection was missing it was just being reported really badly.

To install the required feature start up “Server Manager” and select “Add roles and features”. Click next until you get to “Features” and then select “WebDAV Redirector” and install it, you’ll need to reboot the server afterwards. It seems that prior to Windows Server 2008 R2 this feature was installed by default, as luck would have it the previous machine I was working on was Windows Server 2008.

I don’t want to tell you how long it took me to figure this out but hopefully someone will come across this post and it’ll save them some time.

Building a Media Centre

I enjoy a good film and in my youth I used to love going to the cinema but as I got older I found the cinema became far too expensive for the reward and I just didn’t have the time anyway. Since I enjoyed watching things on the big screen the natural answer was a projector and for years I played DVD’s on a computer though a projector. Around ten years ago though the projector blew a bulb and, as I had other things on, it never go replaced. A couple of months ago though I bought a new projector and now I’m looking to set up a full home cinema.

Continue reading

Script Must Not be Null or Empty

I’ve just started learning Spring / Spring Boot so I’m at that stage where I’m making all the stupid beginner mistakes. In the past I used to catalogue the problems I hit, especially when learning a new technology. A few people told me they found it really useful so I’ve decided to start again. This particular issue I ran up against didn’t take long to figure out but the message on the exception isn’t as clear as it could be so I thought it was worth documenting.

Continue reading

Digikam Tagging

I’ve recently switched from Picasa (which has been retired) to Digikam for photo management and I’ve noticed a few quirks that I need to document to or I’ll forget them. For the most part Digikam is a massive upgrade over Picasa but a few things in Digikam don’t necessarily work quite as I’d expect them to.

Continue reading

No Boot Space No iNodes

When I set up my QEMU virtual machine system I made a couple of mistakes. As I was running on a host that had very limited resources I made the virtual machines as small as I possibly could and that has come back to bite me at bit. The two problems I seem to constantly suffer from are running out space on the boot partition and, on one machine, running out of inodes.Continue reading

My List of Useful Utilities

I hate to think how many computers I’ve built and installed over the years. I’ve found that there are a core set of utilities that I keep coming back to that I’ve found really useful on most installs. As I only use some of them infrequently I thought I’d put together a list so that in future I don’t forget any, perhaps this list will be useful for you as well.Continue reading

cPanel Addon Domain Management

In this article I discuss cPanel addon domain management and what you need to do to prevent your website being accessible by multiple different domain names when you run more than one site using cPanel (known as add-on domains). You don’t want a site to be accessible by multiple different domain names as you’ll suffer a duplicate content penalty in search engine listings.  Continue reading

Windows 10 Start Menu – That’s Useful

I’m not normally one to complain about Windows, there’s more than enough people doing more than enough complaining about it that I don’t feel the need to add my own frustrations but the start menu made something snap inside me just now and I had to let those frustrations see the light of day.

Continue reading

Fastest Updates in SQL Server

The project I’m working on at the moment requires me to achieve the fastest updates I can into a moderate sized SQL Server database table. My initial attempts were adequate for the testing I was doing on my development machine but when I came to do a more thorough test in a production like environment I found that the method I was employing wasn’t even close to fast enough. At that point I seriously considered just giving up, the difference between what I had and what I needed didn’t look like an “I’ll give it a tweak” type problem it was a vast performance gulf that had to be crossed. The solution was to better understand both my application and SQL Server and here’s what I did.Continue reading