After running a Bulk Insert statement against a file I got the following error.
Msg 4861, Level 16, State 1, Line 29
Cannot bulk load because the file “FileName” could not be opened. Operating system error code 5(Access is denied.).
I gave myself and SQL Service account Full control and couldn’t fix it. The setup I was running was Logged into a different Server using RDP, then openned up management studio, and connected to a different server to run the command. The fix was to rdp to the server where I was running sql server. This seemed to fix it. Another blog had a similar situation and fixed using tcp/IP and not named pipes but this didn’t apply to my situation
Blog on similar issue.
http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/thread/7b87d35f-7b08-4727-9544-8dd7035c5e87/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment