SQL Server error: Cannot bulk load - Operating system error code 5 (Access is denied)

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Views:: 1,100

Visibility:: Public

Votes:: 0

Category:: ontap-9

Specialty:: cifs

Last Updated:

Applies to

ONTAP 9.7
Microsoft SQL Server

Issue

The following error may be seen when Microsoft SQL Server tries to access files on the CIFS share:

Cannot bulk load because the file \\LIF_DNS_NAME\Share1\RemoteApps\SQL Data\Rawdata_1.csv could not be opened.

Operating system error code 5 (Access is denied.)

Windows Explorer can access the same file without the error