Jamie Ashton (2/3/2012)
Hello,I have a situation where I am trying to do a bulk insert of a file that's on a network share. It's failing with:
Cannot bulk load because the file "\\Server\Folder\File" could not be opened. Operating system error code 5 (failed to retrieve text for this error. Reason: 15105).
What I think is odd though is that use of xp_FileExist confirms that that the file exists and the SQL Server can see it.
The remote folder has permissions for "Everyone". Is there an internal setting in SQL Server that has been set to prevent me doing this? It's a new server and so this has never been done before. But it worked fine in pre-production, on a different server.
Hope you can help.
J
Error code 5 is permissions, so it might be worth checking that whatever account your SQL Server runs under has permission. Check the account used by the pre-production server and see if it's using the same.