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

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!!!




Your feedbacks are most welcome..