This error “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.” appears with various possible ways. I have tried googling and everybody has given a solution to provide permission to Managed Metadata Service Application. But, this didn’t fix my issue.
I have looked at the ULS logs, it gives me access error as below.
Exception occured while connecting to WCF endpoint: System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied. Server stack trace:
The below are possible solutions for this issue.
Solution 1: Check your IIS and check IUSR is added in Anonymous Authentication. Here are the steps.
Open the IIS and click on ServerName in left pane. Now Click on Authentication in middle pane as shown in below screenshot.
Right Click on Anonymous Authentication and select Edit option.
Click on Specific User radio bution and click on Set Button. The below dialog appears. Type IUSR in user name field and click on OK button.
Here is the below screenshot once you set the IUSR user. Click on OK button. Now, you try to navigate managed metadata service from central admin. This will fix your issue.
Solution 2: Could be a permission issue on Managed Metadata Service Application. Check the below link for the fix.
Go to SharePoint Central Administration Site –> Application Management –> [Service Applications] –> Manage service applications
Highlight the Managed Metadata Service that your web application is associated with. (Do not click on the link, just click somewhere else on that row to highlight it)
Click on Permissions button in the ribbon area.
Add the application pool account used by your web application and give it at least ‘Read Access to Term Store’
One of the most talked about capabilities since the launch of SharePoint 2010 is the Managed Metadata Service. For those of you who aren’t already familiar with this service and the support it provides for modelling and deploying a rich corporate taxonomy. For those who need get to the basics, configuration & related features for it, we would recommend going thru the links available at “Managed Metadata and Taxonomy in SharePoint Server 2010“
We would use this blog post to bring about some additional information on situations which you might face in day to day work .
The Taxonomy Field is lookup field.
The taxonomy field is a lookup field. The lookup list associated with this field is called the Taxonomy Hidden List. This list is located at http://siteURL/lists/taxonomyhiddenlist. It exists only on the root web of the site collection, and is used as lookup by all the site/list taxonomy fields within that site collection.
Every time a term is used for tagging an item, an entry is made for that term in the Taxonomy Hidden List. The entry will differ depending upon whether the term was used in a Managed Term field/ Enterprise Keywords field. Here is a blog which talks about this in more details Dissecting the SharePoint 2010 Taxonomy fields
Users can’t see the values of the Managed Metadata Columns for list items
Users can browse to the site & see list items etc. but they are not able to see values in a metadata column on a SharePoint list. The only users who can view the item are Site Collection Administrator and any user who was given permissions from policy for Web Applications. This occurs because of missing permissions on “TaxononyHiddenList” for the site collection . By default the “TaxonomyHiddenList” has unique permissions assigned as below for a Classic Mode Web-Application .
Read Permissions should exist for the following principals based on the Classic Claims mode of the Web-application
NT AUTHORITYAuthenticated Users
All Authenticated Users
Site Collection Import /Export OR Backup /Restore OR Content Deployment Scenarios across Farms
Use of Termsets & Managed Metadata columns has found increased usage in Lists either directly or via a content types which provides a Metadata column . Once a user adds a Tag to the list item the list Column is updated with Value of the TAG along with the TermID for the Taxonomy Tag.
Explained as below we see List Metadata Columns Test11 & Test 12 & Terms in use as seen from List Items & Taxonomy Hidden list . Notice how we store this column values in SQL for List “DocLibSC2” . The format used is TermName|IDForTerm .
NOTE: It is not recommended to execute SQL queries against the SharePoint databases.
Now if we Export /Import or Backup /Restore or Do Content deployment across farms , we are able to get the list Items Along with the Values of Tags in Metadata columns ( due to fact that we carry the contents of TaxonomyHiddenList along ) but they would not resolve or Match up to a Term in Termstore published by managed Metadata service on Destination farm . Even If we have the Termset/Terms with same name created on the Target Farm the ID’s won’t match . This would lead to the Metadata column values being Greyed out (un-editable ) & other inconsistencies .
These are the Scenarios where you would want to move contents from One Environment to another to ensure Term sets/Terms are also available to target environment . Two ways to make thing work in these scenarios are
a. Publish the Managed Metadata service Application on the Source farm or any other Services farm & ensure that both Source & Target farms consume the Managed Metadata from this same location. Please refer to articles below to Publish & Consume Managed Metadata services
Note : With the OverwriteExisting switch it maintains the name space. Also if there were terms in the destinations that are not in the import file, then it removes them. In other words, the only items in the term store will be the ones you import in. Nothing more and nothing less.
Note: The Path Specified in Import-SpMetadataWebServicePartitionData has to a location on Shared Location on the SQL server of the farm & ensure SQL & Sharepoint Service accounts have required access . Refer to Post Here for more details