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

    Recent items


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.

Published in SharePoint