SQL Server 2005 Permissions Question - I think
Posted on 2010-09-08
I have the following SQL statement that returns the error shown.
BULK INSERT dbo.tablename FROM '\\server\xxx\filename' WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '');
msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file '\\server\xxx\filename' could not be opened. Operating system error code 5(Access is denied.).
I have added the SQL Service account as a user on the share and can see the file using that account.
Any ideas would be greatly appreciated!