how to grant SQL Server permission to read from UNC path RRS feed

  • Question

  • I have a stored procedure that reads a flat file with OPENROWSET. If the data file and format file both exist on the network with a UNC path, how do I enable the SQL Server to read the files? We are a large organization and use active directory groups. If I submit a request this should be done for me on the production server, but I need to know how to do it on the test server which I control.
    Tuesday, November 19, 2019 4:53 PM


  • When you're not the DBA, then you need to ask under which account SQL Server runs.

    Then the normal admins of the need to add that account to a group which can read that file.

    Rephrased: You cannot do anything, when you're not an admin.

    • Marked as answer by dmcdivitt Tuesday, November 19, 2019 6:45 PM
    Tuesday, November 19, 2019 6:29 PM