Missing Secure Store Service Sharepoint 2010 Foundation

Posted on 2013-10-11
Medium Priority
Last Modified: 2013-10-28

I started with an issue regarding the Business Data Connectivity on my Sharepoint 2010 Foundation server.  I am receiving the error: "The Business Data Connectivity Metadata Store is currently unavailable."

After researching it for a long time and visiting many many sites (most of which were either the Enterprise or Standard versions, not Foundation, OR they would explain how to do something, but I am unable to do certain steps), I have come to the point where I need to post my own topic before I bang my head too hard against a wall.

I got to the point where I should create/add the Secure Store Service.  But lo, this option did not exist anywhere in Central Administration.  Nor could I follow anyone's steps to add it because the options they said to click were not available.  Very frustrating.  Plus it is very time consuming getting through half of a post (multiple times) only to find out the author is using Enterprise, not Foundation.

This user explains the issue I'm dealing with currently and the image they took of the Manage Service Applications section in Central Administration is exactly what I'm seeing:
Similar Post

However, this user apparently resolved their issue by logging in as a Farm Admin.  I am logged in as a Farm Admin and still do not see any way to add the Secure Store Service!  There are a number of things missing that I need to "install" or create, but I cannot figure out how.

When I setup this server, I did not know much about Sharepoint at all, so it is likely that I may have skipped certain important steps.
Here are a few screenshots of what I'm running into.  I do believe the issues are related between the SSS and BDC.  Hopefully this helps:
Manage Service Applications screenshotRunning Sharepoint Services in Central AdministrationSharepoint Designer error when clicking External Content TypesWhen clicking External Content Types in the ribbon in Sharepoint DesignerCannot Create External List
I am running Sharepoint 2010 Foundation x64 on Win Server 2008 Std.
Again, it may be worthy to note that I am not sure if I installed Sharepoint correctly when the server was setup 2 years ago, but I do not know what I am looking for to determine that.

Sorry for the novice approach to this, but that's why I have you all here, right?  ;)
I would like to start off with this by setting up the Secure Store Service and then I'll post a new topic for the BDC errors if I still have an issue then.

I greatly appreciate any guidance / help anyone can provide.


Question by:USSC-IT
  • 3
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 450 total points
ID: 39565703
so you have two issues:
Issue 1: Secure Store Service
Unfortunately the Secure Store Service is NOT part of SharePoint Foundation !

See the note on topic 3 in this post on the first figure:

But AFAIK there is a workaround for getting another Secure Store Service which is part of Microsoft Search Server Express. There is an additional patch for MSSE fixing a "Trial expired message":

To issue no. 2 - error in regards to BCS error in SharePoint designer: could you please have a look into the SharePoint ULS logs (C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\logs), into the Windows Event log for any errors there?
Perhaps you want to delete and recreate the BCS service application.


Author Comment

ID: 39578139

Thanks for the reply.  I am looking into your suggestions.

1. From what I've read, I could install Search Server Express on top of Foundation, but that it MAY break things.  I do not want anything breaking and do not have the hardware to assign for a 2nd Sharepoint farm. (as someone had suggested installing SSE on a 2nd farm and linking it back to the 1st farm)

2. I took a look at a couple logs and did see an Access Denied error.  It referenced my domain account, but I do not know what invoked it.  I rebooted the server, so I can't tell you anything more about those logs at this time.

Accepted Solution

USSC-IT earned 0 total points
ID: 39595104
We have decided to make use of a decommissioned server and rebuild it to host the Sharepoint server.  So I'm going to take the route of rebuilding Sharepoint from scratch and hopefully it'll be better/cleaner this time around. ;)

Rainer, thanks for your response and your solution was likely to have fixed our problem, but given the situation we chose to rebuild.


Author Closing Comment

ID: 39605110
Rebuilding from scratch.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question