Sunday, November 3, 2013

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

When accessing Managed Metadata Service the following message is prompt:

"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"

I have done everything that i found on internet on Production and Quality SharePoint Environment and no solution worked for my Production Environment

What i have done:
  • Verify the “Managed Metadata Web Service” is "started". Reset several times..
  • Recreate the Service Application “Menaged Metadata Web Service”. Set full Permissions on and all others services account in hope it will work..but it didn't happen. It's not permissions issue.
  • Publish the same Service Application
  • Verify the Service Application Association have Managed Metadata Service is checked.
  • Dedicated Application Pool
  • Several iisresets

1 - Solution for Quality Environment: Create a new dedicated Application Pool 
  1. Go to Central Administration
  2. Click Application Management, then Manage Service Applications
  3. Select Managed Metadata Service and click Properties
  4. Create a new Application Pool



2 - Solution for Production Environment: Reattach Managed Metadata Database
This took me a harder solution.

  1. Go to SQL Server detach "Managed Metadata Database". Note: Select "Close Connection" option
  2. In Central Administration, Delete "Managed Metadata Service Application"
  3. Note: DO NOT Delete data associated with the Service Applications, You are deleting YOUR Database!!!
  4. Create a new Managed Metadata Service Application with a different name from the original DatabaseNote: Select the check-box "Add this service application to the farms default list".
  5. Take the newer database offline and close connections(At the end of this solution, this DB can be deleted)
  6. Do an attach of the original database
  7. At Central Administration, go to properties of managed Metadata and change the name to the original Database
  8. Do an iisreset






4 comments:

  1. Looks like I might be drawn one of these options on my dev server. My MMS has suddenly showing this error: Permissions all correct haven't changed and MMA and the web service are both started..

    ReplyDelete
    Replies
    1. Weird, I am also getting this error from time to time..
      Looks like it's a schedule job. Have to find out.

      Delete
  2. A variation of 2 worked for me:
    1) delete service application without deleting the database
    2) recreate service application with new placeholder database
    3) edit service application to use the previous database
    4) review functionality, delete placeholder database

    ReplyDelete
    Replies
    1. You doing a soft solution 2, which only remove the Service Application and add a new one :)
      I'm glad it worked for you.

      Delete