PerformacePoint Services and Secure Store Services
When Im setting up secure store service, I want to locate the content db to another database server other than SharePoints database. When I do this I get the following error: The timer job completed, but failed on one or more machines in the farm.
Would you know a work around? Thanks
Would you know a work around? Thanks
Last Comment
Justin Smith
You want to move it to another server? Or you want to create it on another server?
ASKER
The Secure Store Services has not yet been enabled so Id like to enable this service and have the db created on a different server other than the default (SharePoint database server)
Does the database server added to your SharePoint farm?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yes the other SQL database server is already attached to the farm.
ASKER
When creating the service app, just designate the correct db server in the server name box
I already tried doing that ... everything looked like it was going to work however I received the following message: The timer job completed, but failed on one or more machines in the farm. then the Secure Store Service App shows an error.
I already tried doing that ... everything looked like it was going to work however I received the following message: The timer job completed, but failed on one or more machines in the farm. then the Secure Store Service App shows an error.
How exactly did you attach the SQL server to the farm? SQL boxes aren't "attached" to the farm.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
When I go to Central Admin ... System Settings ... Manage Serves in this Farm: I see the other database server other than than the default SharePoint database server
Can you answer my last question?
ASKER
The Farm Admin did not have the securityadmin role. Once I gave the Farm Admin that role ... I still received the error message.
However, once I deleted the content db from the SQL server and had it recreate it I was good to go. The Secure Store Service seems to be properly setup now.
The issue seemed to be a combination of two things: the content db was already created and the Farm Admin did not have the securityadmin role.
However, once I deleted the content db from the SQL server and had it recreate it I was good to go. The Secure Store Service seems to be properly setup now.
The issue seemed to be a combination of two things: the content db was already created and the Farm Admin did not have the securityadmin role.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
More than likely yes. Thanks!
Microsoft SharePoint
Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.
40K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
