ASP. net MVC 4 – You do not have permission to use the bulk load statement.

Posted on April 6, 2018 by Suresh Kamrushi in asp.net

When trying to execute store procedure having bulk insert, getting error as
You do not have permission to use the bulk load statement.

Error is popping up due to permission is not granted to SQL user accessing DB. So Below I am sharing how you can provide permission to user to fix this issue.
1) Go to MS SQL server management and connect to db.
2) In Object Explorer, go to Security and then login.
3) Look for your user and right click on it.
SSMS - objecte explorer
4) “Login Properties” popup will open
5) Click on “Server Roles” and check “bulkadmin”.
SSMS - Login Properties

Now if you try to execute again you must not get the error.
Hope this will help someone!!!

  Comments or questions are welcome  

Tagged as , ,