Missing Secure Store Service Sharepoint 2010 Foundation


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.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
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.

USSC-ITAuthor Commented:

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.
USSC-ITAuthor Commented:
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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
USSC-ITAuthor Commented:
Rebuilding from scratch.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.