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.

Solution

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).

Maximum number of products for given amount from the product list in SQL server without using While/Cursor?
How to find which Database Roles are associated with a given User?
Last executed queries for a specific database
How important is the order of columns in indexes?
EF Core: what exactly is the command timeout measured on?
sql server invalid object name - but tables are listed in SSMS tables list
How to execute a stored procedure inside a select query
Applying a rename migration with a temporal table throws SqlException (0x80131904) mismatching number of BEGIN and COMMIT statements
Heterogeneous queries require the ANSI_NULLS
Query to parse JSON using openrowset converting special characters
How to delete cascade on Memory-Optimized tables?
Object reference not set to an instance of an object: on Publish
SSRS 2014 date range parameters not working with an OR clause
Calculate duration using T-SQL
Conversion failed when converting the nvarchar value to data type int while inserting records into table
How to split a column into 2 different columns with condition
How can I run just the statement my cursor is on in SQL Server Management Studio?
SQL rollup to add a total row for multiple columns
Select SQL Server database size
INSERT INTO a temp table, and have an IDENTITY field created, without first declaring the temp table?
Create single image for database diagram in SQL Server
Automatically define the DataTable in C# from the schema of SQL server tables?
TSQL: how to write this query?
CREATE TABLE permission denied in database 'tempdb'
The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
Does database compound index order matter if the first column is only queried with an equal operation?
Difference between .NET, OLEDB, and Native Providers in SSIS
Is there a way to populate a HTML table from a database? (SQL Server, VB.NET, ASP.NET)
ExecuteScalar() not returning full contents of cell
Why does normal execution resume after Raiserror in Catch block