While I was working on one of my Windows 2012 servers, I needed to run an internal SSRS utility.
This utility allows you to browse for a file and create a ton of stored procedures within SQL. However, to run it on Windows 2012, I had to run it using elevated permissions and therefore I lost access to my network drives. This meant that I needed to copy the files from my network drive to the server’s desktop, execute my program, and then point to the file.
Understandably, this was a pain, so I spent a little bit of time researching this issue and I found that there is a quick fix!
First, create an EnableLinkedConnections registry key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System with the value of 1.
This allows me to see all of my network drives and therefore I can browse for the files using the utility without all the messing around. That’s it!