GSquared (9/30/2011)
...So, if you connect from your workstation to a server, your workstation passes credentials to the server. That's "single hop" or "single step"....but telling it to connect from your workstation, to the database server, and then to a UNC path that probably connects to a different server, is double-hop, and either needs kerberos, or for the anonymous login to have access to the UNC destination.
10 years of working with SQL Server and 10 years of logging into the server directly just so I can run an OpenRowSet command that uploads my XLS and XLSX templates. I sure wish I would have found this and understood it back in 2011 when it was posted. I've tried many times to use the server query on my local workstation and couldn't get it to work. Both computers have "P" drive mapped to the same share and due to my lack of network understanding, I just assumed if "My Computer" can show it, then it must be a valid path. I always assumed it was an OLEDB issue and never considered the credentials, much less double-hop credentials. Gotta love these SSC forums!