Skip to content
Are Flyen's Blog

Are Flyen's Blog

Office 365, SharePoint and Azure

  • About
  • Archive
  • Contact

Tag: Managed Metadata

Posted on August 21, 2014August 21, 2014

The Managed Metadata Service or Connection is currently not available in SharePoint 2013

Problem

Error in Central Admin when accessing the Managed Metadata service application:

The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.

 

Error in ULS log:

Failed to get term store for proxy ‘Managed Metadata Service’. Exception: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

 

Error in Event viewer:

The Managed Metadata Service ‘Managed Metadata Service’ is inaccessible.

 

I did investigate many suggested solutions out there, and the most similar description of the scenario I found here:

http://sharepoint-community.net/forum/topics/failed-to-get-term-store-for-proxy-managed-metadata-service

 

Previously I had tried to re-create the service application with the same database, but it failed in the same way. So this pointed me to that the error was within the database, not permissions in Central Admin, AppPool trouble, services etc.

 

As someone mentioned in the discussion above, you might have to create a new database and restore the data. In my case this was on a development environment, so backup/restore you said? Luckily i managed to make a way through this problem without scratching the database for good.

 

Solution

These steps solved the issue for me: 

  1. Go to “Central Administration” and select “Manage service applications”.
  2. Select your Managed Metadata service application, in my case with almost that name and the button “Properties”:
    1. mms-error-1
  3. Locate the “Database name” and change this one to for example “SP2013_MetaData_NEW”. Remember to take a note of the old database name for the next steps:
    1.  mms-error-2
  1. Select “OK” and give it some time. SharePoint now creates a new database for you with the name selected above. When it has completed, try to open the service application (Manage) and it now should open without problems, but as expected with an empty term store.
  2. Go back to the list over service applications and repeat step 2. Now enter the old database name instead, in my case “SP2013_MetaData” and select “OK”.
  3. Wait some more an access the service application again (Manage). For me it looked like nothing had changed and I now only saw the new database, but I was missing permissions.
  4. Locate the “Term store administrators” and at least add your admin user here:
    1. mms-error-3
  5. Select “Save” and now with the correct permissions you should have access to the existing Term Store and the service application would be back to normal.

 

Note: before performing these steps I had re-created the service application with the existing database. It can be possible that this was necessary to succeed.

Are Flyen

Are Flyen is a developer and solution architect located in Norway. He works with SharePoint, Office 365 and Azure as a Chief Consultant at EVRY.

Recent Posts

  • Use the Full Page Canvas in modern SharePoint Online sites
  • Create a Communication Site from code in SharePoint Online using PowerShell
  • Problem with connecting to SharePoint Online in Office 365 with PowerShell, SharePoint Designer and other 3. party tools
  • “Create a team” is missing in Microsoft Teams
  • Create list from custom template in SharePoint with PowerShell

From Twitter

  • Blogged: Use the Full Page Canvas in modern SharePoint Online sites blog.areflyen.no/2018/04/05/use… #SharePoint #SPFx 2 years ago
  • Blogged: Create a Communication Site from code in #SharePoint Online using #PowerShell blog.areflyen.no/2017/07/16/cre… 3 years ago
  • Blogged: Problem with connecting to #SharePoint Online with #PowerShell (LegacyAuthProtocolsEnabled) blog.areflyen.no/2017/06/18/pro… 3 years ago
  • "You site collection is being created. It can take 15 minutes or longer to complete this task." #Performance #HopefullySoonHistory 3 years ago
  • Enable ratings with PowerShell and CSOM in #SharePoint: blog.areflyen.no/2016/09/11/ena… 4 years ago

Tags

  • Active Directory
  • API
  • Authentication
  • BCS
  • Collaboration
  • Development
  • Development environment
  • Error
  • Hyper-V
  • Integration
  • Intranet
  • ITPRO
  • Managed Metadata
  • Microsoft Teams
  • Migration
  • MySite
  • Navigation
  • Office 365
  • Office 365 Groups
  • OfficeDev PnP
  • PowerShell
  • Profile Pictures
  • Publishing
  • React
  • SharePoint 2010
  • SharePoint 2013
  • SharePoint 2016
  • SharePoint Framework
  • SharePoint Online
  • SkyDrive
  • Social
  • SPFx
  • Troubleshooting
  • TypeScript
  • Upgrade
  • User Profile
  • User Profiles
  • Web Parts
  • Windows 8
  • Windows Server 2012
  • Workflow
  • Yammer

Menu

  • About
  • Archive
  • Contact
Blog at WordPress.com.
Cancel