asp net mvc 4 not permission use bulk load statement

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.

4) “Login Properties” popup will open

5) Click on “Server Roles” and check “bulkadmin”.

Now if you try to execute again you must not get the error.

Hope this will help someone!!!

Originally published at http://sforsuresh.in.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store