SQL Server error: Cannot bulk load - Operating system error code 5 (Access is denied)
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