Home Forums SQL Server 2012 SQL 2012 - General OpenRowSet works locally but not over networked drives RE: OpenRowSet works locally but not over networked drives

  • July 10, 2013 at 12:09 pm

    #1631346

    Elliott Whitlow (7/10/2013)

    erikd (7/10/2013)

    I checked that, actually. Not only can I use xp_cmdshell to DIR the path, but I can insert the results into a table. Weird, huh?

    You might have hit on something there.. I had a similar problem and the issue was the file was being written with permissions that wouldn't allow SQL to access it. So now I guess you need to see what permissions the actual file has..

    CEWII

    All users and groups, including Everyone, has all permissions allowed on the file, except Special Permissions. The only group that has Read and Read/Execute only are local users, which the clients\SQLService domain account isn't.

    So, do I need to give "Special Permissions"? These permissions don't seem special, but what do I know?