March 15, 2006 at 9:32 pm
Does any one know what user account is being used by BULK INSERT command when accessing data file and format file?
My problem is the user account that I use to run bulk insert has full control access to the folder where the data file is located but when I execute the bulk insert command I get this error message:
Could not bulk insert because file '\\<server>\<folder>\file.txt could not be opened. Operating System error code 5 (error not found).
Permission to 'Everyone' was removed when <folder> was shared and the user account that I am using has Full Control access. But when we added back 'Everyone' in the share permission, the bulk insert ran successfully which means that BULK INSERT command is using a different user account to access data file.
March 15, 2006 at 11:37 pm
Has the SQL Server service account being granted READ permissions to the folder?
March 16, 2006 at 3:59 am
The SQL Server service account was not granted read permission to the folder. When we granted it read permission to the folder, the bulk insert ran successfully.
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply