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

Hi. I get the following error when trying to run the following SQL in my VB.net application "You do not have permission to use the bulk load statement"

CREATE TABLE myTable(Document varbinary(max)) 
INSERT INTO myTable(Document) 
SELECT * FROM 
OPENROWSET(BULK N'C:\Users\murbr\Pictures\MyFilter.jpg', SINGLE_BLOB) 

Open in new window

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
What kind of permissions do you have?
If you don't have sysadmin role then you'll need to have permissions for BULK OPERATIONS:
GRANT ADMINISTER BULK OPERATIONS TO <LoginName>

Open in new window

0
 
Ryan ChongConnect With a Mentor Commented:
try add in Server role: bulkadmin ?
0
 
Ryan ChongCommented:
for my comment above
SnapShot.png
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.