PerformacePoint Services and Secure Store Services

Cyber IT
Cyber IT used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
You want to move it to another server?  Or you want to create it on another server?  
Cyber ITEngineer

Author

Commented:
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)

Commented:
Does the database server added to your SharePoint farm?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Justin SmithSr. System Engineer
Top Expert 2012
Commented:
When creating the service app, just designate the correct db server in the server name box
Cyber ITEngineer

Author

Commented:
Yes the other SQL database server is already attached to the farm.
Cyber ITEngineer

Author

Commented:
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.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
How exactly did you attach the SQL server to the farm?  SQL boxes aren't "attached" to the farm.
Sr. System Engineer
Top Expert 2012
Commented:
Does your Farm admin account have dbcreator and securityadmin roles on the other SQL server?
Cyber ITEngineer

Author

Commented:
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
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Can you answer my last question?
Cyber ITEngineer

Author

Commented:
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.
Justin SmithSr. System Engineer
Top Expert 2012
Commented:
The reason you had that issue is because the faarm account couldn't properly set security on the db since it didn't have securityadmin permissions.

Please close this ticket out.
Cyber ITEngineer

Author

Commented:
More than likely yes.   Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial