You do not have permission to use the bulk load statement

Hi I’m getting the error

You do not have permission to use the bulk load statement.

when I try to execute a stored procedure.

I’ve seen some websites mentioning about the bulkadmin role, but I don’t see it.

I’m using SQL Server 2008.

Any ideas?

Contents hide

Answers:

Method 1

Method 2

Method 3

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Start SQL Server Managament Studio
Expand Security->Logins
Locate your user, right click on it and take Properties
Open Server Roles tab
Make sure that bulkadmin is checked.
There you can experiment with other roles if bulkadmin doesn’t work for you.
Click OK 🙂

Method 2

Query version for Aleksandr’s answer:

EXEC master..sp_addsrvrolemember @loginame = N'%userName%', @rolename = N'bulkadmin'
GO

Just replace %userName% with desired user.
Also you need to be loged in as Sys-Admin (sa) or other user with EXEC permissions and bulkadmin granting permission.

Method 3

You can provide permission to user to fix this issue.

Go to MS SQL server management and connect to db.
In Object Explorer, go to Security and then login.
Look for your user and right click on it.
“Login Properties” popup will open
Click on “Server Roles” and check “bulkadmin”.
Now if you try to execute again you must not get the error.

Source: http://sforsuresh.in/asp-net-mvc-4-not-permission-use-bulk-load-statement

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating