• This email address is being protected from spambots. You need JavaScript enabled to view it.

    Recent items


Friday, 27 July 2012 10:18

Import-SPMetadataWebServicePartitionData: You do not have permission to use the bulk load statement

Written by
Rate this item
(2 votes)

During a Term store import, you can incurr in a "Import-SPMetadataWebServicePartitionData: You do not have permission to use the bulk load statement" error as image below.

To resolve this problem, you must add the Managed Metadata Service Application user into bulkadmin DB role.

  1. If you don't now Managed Metadata Service Application user
    • open IIS Manager
    • search the Metadata Application Pool (select an Application pool, click on "View Applications" and see if contains the Metadata Service)
    • when you find the Metadata Applciation Pool, the Identity user is the Metadata Service Application user.
  2. Open Microsoft SQL Server Management Studio
    • click on Security, Server Roles, and double click on bulkadmin Role.
    • in the new window, click on add and write the user finded on the previous step.

After this operation, you can Import your Metadata without problems.

Read 129660 times Last modified on Sunday, 25 November 2012 16:39


  • Comment Link Does Truth About Abs Work Monday, 30 September 2013 04:26 posted by Does Truth About Abs Work

    Tremendous issues here. I'm very glad to look your post.
    Thanks so much and I'm taking a look ahead to contact you.

    Will you please drop me a mail?

  • Comment Link Paleo Recipe Book Review Friday, 18 October 2013 11:41 posted by Paleo Recipe Book Review

    Good blog you've got here.. It's difficult to find
    good quality writing like yours nowadays. I honestly appreciate individuals like you!

    Take care!!

  • Comment Link Wednesday, 21 May 2014 23:43 posted by

    My coder is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the costs. But he's tryiong none the less.
    I've been using Movable-type on a number of websites for about a year and
    am concerned about switching to another platform.
    I have heard very good things about
    Is there a way I can import all my wordpress content into it?
    Any kind of help would be really appreciated!

  • Comment Link link Sunday, 25 May 2014 23:22 posted by link

    Everything published was actually very logical. But, think
    about this, what if you were to create a awesome title?
    I am not saying your information is not good., however what if you added
    a title that grabbed folk's attention? I mean Luca Costante - Import-SPMetadataWebServicePartitionData: You do not have permission to use the bulk load statement is
    kinda vanilla. You could look at Yahoo's home page
    and see how they write article headlines to grab viewers
    interested. You might add a related video or a picture or two to get people excited about
    what you've got to say. In my opinion, it could make your posts
    a little livelier.

  • Comment Link Luca Costante Thursday, 05 June 2014 12:27 posted by Luca Costante

    Thanks link for your consideration, I'll keep it in mind for the next articles

  • Comment Link Ngan Sunday, 20 July 2014 05:04 posted by Ngan

    Hello there, just became alert to your blog tnrough Google, and found that it's truly
    informative. I'm going to watc out for brussels. I will appreciate if yoou ontinue this in future.
    Lots of people willl be benefited from your writing.

  • Comment Link personal finance software reviews Monday, 13 October 2014 20:44 posted by personal finance software reviews

    I am genuinely happy to glance at this website
    posts which includes plenty of helpful information, thanks for providing
    these data.

  • Comment Link Thursday, 20 November 2014 15:19 posted by

    Amazing! Its actually remarkable article, I have got much clear idea
    about from this article.

  • Comment Link pletcherdbm Monday, 29 December 2014 07:55 posted by pletcherdbm

    Thank you! You really did a great job! I will support you all the time.

  • Comment Link carpinteyroebn Monday, 29 December 2014 07:56 posted by carpinteyroebn

    It is a way to show your respect to the author if you can read the articles patiently and give your feedback.

  • Comment Link Mr.Makingusmile Monday, 08 June 2015 05:44 posted by Mr.Makingusmile

    These are genuinely great ideas in about blogging.
    You have touched some fastidious factors here. Any
    way keep up wrinting.


Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.