Cannot bulk load the file does not exist sql

The user account that is used by SQL Server must have been granted the permissions that are required for reading the file on the remote disk. You could also refer this article for more details. If the answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Regarding to the SPN, if you have enough permission of setspn, you could refer the article I provided earlier to list, add,or remove all SPNs. Previously it was working fine with. Actually there was some patch update from Microsoft side to win server and SQL server.

After this, I was unable to connect to SQL server. So I had to update the jdbc driver and java version. I was able to connect after doing jdbc update and java version update. You will need to talk with your DBA and other admin folks to sort this out. You really need to know what it says in sys. It certainly smells as a double-hop issue with Kerberos. ErlandSommarskog is it necessary for the file server to be present in AD domain for kerberos authentication to work properly?

Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. Related Questions. Bulk Insert Error in Sql Server. Bulk Upload in c and Sql server. Bulk insert causing issue in sql. Please solve me SQL syntax error problem. Bulk insert in sql server. Problem to insert arabic words in SQL server. How to perform bulk insert to SQL table?

And then, we will import the data back from the table. Use the following bcp. It was the false and misleading error. But what to do if you specify the correct name and still receive this error? All you need to do is to give SQL Server access to the folder. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Learn more. Access is denied" on a file I have access to Ask Question. Asked 3 years, 7 months ago. Active 3 years, 7 months ago. Viewed 14k times. Improve this question. Kenneth Fisher Kenneth Fisher It's an issue with permissions on a service account and probably not your own, while you are in SQL Server, it is going to use the SQL Server Service account to access the file or a proxy account or an account running the job.

Also maybe a bug? Good suggestions though : — Kenneth Fisher.