Post reply

Access denied for bulk insert data file

  • March 30, 2005 at 10:43 am

    #85654

    Hello,

    I'm trying to run a script to load a table via bulk insert from a datafile usinq Query Analyzer. When the datafile is local to the SQL Server server it works fine. When it is on my PC I get an OS error access denied. I read in BOL about having to use the UNC path for files not local to the server, but who/what permissions do I need to access the file from QA. I'm logged into the database with my network account and am a db-owner for the database.

    Thanks,

    Mike Lamar

    --

    Mike_Lamar@baylor.edu

  • March 30, 2005 at 11:03 am

    #549599

    The SQL Server service account needs read access to the directory in question.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply