erikd (7/10/2013)
Elliott Whitlow (7/10/2013)
erikd (7/10/2013)
I've given the clients\SQLService user explicit rights to the folder. from Full Control on down. Nothing is denied. I immediately ran the query, and got the same error as my original post. Let me know if there's something additional I should do (reboot, wait for replication of some sort, etc.).Thanks
Did you apply the change to existing files? I'm guessing that might be it..
CEWII
Yes, sorry, I applied it to the file itself. Same error. I even went a little crazy and gave the clients\SQLService account full control of every drive and directory on down to the file.
Grrrrrr... Ok, what if you do a:
EXEC master.dbo.xp_cmdshell 'TYPE \\server\share\filename.ext '
what is the output? IF it reads it you should get some goofy stuff..
CEWII