Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to enable bulk permission in SQL Server

I am trying to insert images using "bulk" into SQL Server 2012. But, am ending up with the error message stating tha:

Msg 4834, Level 16, State 1, Line 2 You do not have permission to use the bulk load statement.

I have "sysadmin" access.

like image 338
Esh Avatar asked Jan 30 '13 12:01

Esh


People also ask

How do I grant bulk insert permissions in SQL Server?

To grant user ability to run Bulk Insert T-SQL command , login/user needs to be granted: BULKADMIN server role - or - ADMINISTER BULK OPERATIONS server-level permission. connect on target database. insert on target table.

What is bulk admin role in SQL Server?

The bulkadmin fixed server role is the newest of the fixed server roles after being added in SQL Server 2005. This fixed server role grants its members the ability to bulk insert data using BCP, SSIS or the BULK INSERT statement without granting them any additional rights.


1 Answers

Try GRANT ADMINISTER BULK OPERATIONS TO [server_login]. It is a server level permission, not a database level. This has fixed a similar issue for me in that past (using OPENROWSET I believe).

like image 65
tommy_o Avatar answered Oct 02 '22 12:10

tommy_o