April 22, 2016 at 6:45 am
I have an error - "You do not have permission to use the bulk load statement",
so i open up SSMS and add it:-
grant ADMINISTER BULK OPERATIONS TO [domain\AD Group]
but it still fails - why? (and I have two servers I'm playing with, sql server 2014 and a server 2005, some issue)
also interesting is if I log in to the box as an administrator and try same thru the gui it does not work either, says it does but it does not, e.g.
right click on the server
choose properties
choose permissions
choose the [domain\AD Group] name
then check the box that says administer bulk operations
click OK.
but if i open it up again, the box is STILL not ticked and of course the query still fails as i cannot seem to give the permission no matter what i try......
April 25, 2016 at 3:11 am
david mclaughlin (4/22/2016)
I have an error - "You do not have permission to use the bulk load statement",so i open up SSMS and add it:-
grant ADMINISTER BULK OPERATIONS TO [domain\AD Group]
but it still fails - why? (and I have two servers I'm playing with, sql server 2014 and a server 2005, some issue)
also interesting is if I log in to the box as an administrator and try same thru the gui it does not work either, says it does but it does not, e.g.
right click on the server
choose properties
choose permissions
choose the [domain\AD Group] name
then check the box that says administer bulk operations
click OK.
but if i open it up again, the box is STILL not ticked and of course the query still fails as i cannot seem to give the permission no matter what i try......
What permission you have now on your server?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply