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 1:01 pm

    #1631359

    erikd (7/10/2013)

    Elliott Whitlow (7/10/2013)

    I don't really consider those special myself.. Are there other files there that CAN be read by SQL? I'm trying to get a view on what SQL actually needs. Also are there any DENY permissions set?

    CEWII

    I haven't been able to either create in, or create and copy to the folder, a file that can be read.

    When the same files are copied to a local drive, they're read fine. This goes for other file types as well, not just xlsx. Also .xls, .txt, and .csv. I know that doesn't make a ton of difference.

    I'm wondering if the SQL user should be given explicit permissions to this directory. When you copy the files the permissions of the directory usually flow into it. But when you move a file on the same drive the permissions it had come with it. I'm wondering if that might be in play.. But it really feels like we are at the root of the problem, permissions on the file and/or directory. Which would probably NOT be in place on a local drive given the permissions you say this user has locally.

    CEWII