Cannot bulk load. Operating system error code 5 (Access is denied.)

If you are trying to insert bulk data from file using SQL Server and you faced the following error:

Cannot bulk load. Operating system error code 5 (Access is denied.)

Please follow the below steps:

  1- Open Windows services: press Start - > type Services - > Click or tap the matching result.
  2- Right click on SQL Server (MSSQLSERVER) service.
  3- Select Properties.
  4- Switch to Log on tab.
  5- Select Local System Account.
  6- Click OK.
  7- Restart SQL Server (MSSQLSERVER) service : right click on SQL Server (MSSQLSERVER) service -> select Restart.



now try again and you'll not get the same error again.