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.)
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.
EmoticonEmoticon