Operating system error code 5(Access is denied.)

Question

i am getting error when i am triggering stored procedure from application, but i is working fine when executing same procedure from ssms. both the account are same

Cannot bulk load because the file "\f\f1\DEMO\gf3\000000002120220530094502395.txt" could not be opened. Operating system error code 5(Access is denied.)

Answer 1

We don't know much here. You say "both the account are same". What exactly do you mean here? Are you logged into SSMS with the same account as the application is running under? And what sort of application is that? A fat Windows client? A web application?

Here is some information that may help you to troubleshoot the issue further.

You don't say exactly what code you are running, but the error message suggests that you are running BULK INSERT. When you run BULK INSERT, SQL Server attempts to impersonate you when accessing the file. This means that your permissions will apply. This is not much of a problem if you are logged into to Windows on the machine where SQL Server is running.

But if you are logged into to computer A, SQL Server runs on server B and the share is on server C, there is a double-hop challenge. When Kerberos and SPNs are configured correctly it works. But if they are not, the access will instead be by the service account of SQL Server. And if this is a local account, the access will be by the machine account, DOMAIN\MACHINE$.