SharePoint Service Applications

Cyber IT
Cyber IT used Ask the Experts™
on
There are a few service applications that are either stuck in "STARTING" or "STOPPING" mode. How can I stop these services and restart them manually?

Business Data Connectivity Service
Claims to Windows Token Service
Microsoft SharePoint Foundation Workflow Timer Service

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 shouldn't start the first two unless you need them.

Reboot is the quick answer.
Cyber ITEngineer

Author

Commented:
I rebooted several times, nothing.

Im trying to run PerformanPoint Services, SQL Reporting Services Server, and Reporting Services Add-in all on the same box. This box is added to the farm.

What services should be enabled besides PerformancePoint Services?
Cyber ITEngineer

Author

Commented:
I was having trouble getting the Secure Store Services service started on the box so I tested out some other services and now I cant get them out of either "STOPPING" or "STARTING"
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Justin SmithSr. System Engineer
Top Expert 2012

Commented:
How much memory do you have on this server?  
Cyber ITEngineer

Author

Commented:
4GB ... 3GHz

is there a way to manually stop or start a service that is controlled via central admin that is stuck in either "Stopping" or "Starting" mode?
Justin SmithSr. System Engineer
Top Expert 2012
Commented:
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
You may need to bump the memory up.  I've seen strange issues happen when many services are running on a box with only 4 GB.
Cyber ITEngineer

Author

Commented:
The box is actually a VM.

Thanks for the link to manually restart some services... however I can find the service name for those three services listed above.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
This has turned to a 500 pt question bro.
Cyber ITEngineer

Author

Commented:
has it?  :-)

Im trying to run PerformanPoint Services, SQL Reporting Services Server, and Reporting Services Add-in all on the same box. This box is added to the farm.  What services should be enabled besides PerformancePoint Services?

To manually restart some services, I cant find the service name for those three services listed above.
Sr. System Engineer
Top Expert 2012
Commented:
get-spserviceinstance | select name

should help you

Cyber ITEngineer

Author

Commented:
Yes, thanks however I already tried that beforehand.  I couldnt find the actual service name for those three services listed above.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
If you run get-spserviceinstance and don't see PerformancePoint or Claims or Workflow Timer, you have other issues.

Was SharePoint installed as a farm, or did you do a stand alone?
Cyber ITEngineer

Author

Commented:
I just want to stop all services running on this machine that was added to the farm as a WFE. then start the services that are needed to run:  PerformanPoint Services, SQL Reporting Services Server, and Reporting Services Add-in all on the same box, properly.

The ones that I tried to stop are stuck at "STOPPING"

Thanks much!  
Cyber ITEngineer

Author

Commented:
SharePoint was installed as a FARM and connected as a WFE. Central Admin is shared between all WFEs.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Please provide a screenshot of your Powershell command and the returned list.
Cyber ITEngineer

Author

Commented:
I was doing the commands in CMD window using:  C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\stsadm Get-SPServiceInstance

Im not too familiar with Powershell ...
Cyber ITEngineer

Author

Commented:
Screenshot1
Justin SmithSr. System Engineer
Top Expert 2012
Commented:
You need to use the SharePoint Managment Console on the server.  
Cyber ITEngineer

Author

Commented:
You know ... I should have know that one.  I will get the info up soon.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Since you were running commands the wrong way, you should probably follow the stuff in the URL i posted earlier.
Cyber ITEngineer

Author

Commented:
Screenshot2
Cyber ITEngineer

Author

Commented:
The last image of course gave the instances for all the WFEs attached to farm.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Perf Point is started, so that is good.  You don't need to worry about Claims to Windows.  BDC is already started.

So your question was how do I manually stop and start services.  The answer is via PowerShell, going off the Technet article I provided.
Cyber ITEngineer

Author

Commented:
PerformancePoint needs to be started on the WFE that is running SQL Reporting Services, etc. only.
Cyber ITEngineer

Author

Commented:
This is what is running on the WFE that Im in question about. Screenshot3
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Have you manually tried to stop and start them using PowerShell, like I've noted multiple times?
Cyber ITEngineer

Author

Commented:
Yes I have and Im getting an error when doing so.  Im trying to find that instance to delete but cant. UGH! Screenshot4
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Either reboot your box, or go into Job Definitions under the Monitoring section in Central Admin and try to find this job, and delete it.
Cyber ITEngineer

Author

Commented:
OK, I rebooted the box.  Now 6 services are stuck on "Stopping" and the rest are all "Stopped." I cant get these services to be all "Stopped"   I just want to start PerformancePoint Service but that is stuck at "Stopping" for some reason.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
If you look in services.msc (not in central admin).......is the SHarePoint Timer service running?  Sounds like a bunch of jobs are stuck and not correctly processing.  This is because the timer service isn't running, or the jobs are corrupt and need to be manually deleted.
Cyber ITEngineer

Author

Commented:
Yes it is running ... automatically ... with a service account.  So the jobs is more than likely corrupt.  Where can I find and delete ... I went through all the jobs in Job Definitions under the Monitoring section in Central Admin and deleted what was possible to delete.
Cyber ITEngineer

Author

Commented:
I know have three services that are stuck in "Starting" mode...

Claims to Windows Token Service
Microsoft SharePoint Foundation Web Application
Microsoft SharePoint Foundation Workflow Timer Service
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
and you started them through PowerShell?
Cyber ITEngineer

Author

Commented:
I tried to stop them through PowerShell and all I was seeing was "Stopping", some stopped but some still said that so I tried to start them instead.   I just cant seem to get them to Start/Stop via Central Admin
Cyber ITEngineer

Author

Commented:
Something is seriously messed up. When I try to start a service via central admin, the service just sits there saying "Starting..."
Cyber ITEngineer

Author

Commented:
Mind boggling but I got it to work.  I can start/stop services via Central Admin just fine.  I detached the WFE from the farm and reattached it and all seems to work well now.

I however would like to know what services are actually needed to be started to have the following function properly all on one box on this farm:

PerformanPoint Services, SQL Reporting Services Server, and Reporting Services Add-in.

I currently have this started:
PerformancePoint Service
Microsoft SharePoint Foundation Workflow Timer Service
Secure Store Service
Excel Calculation Services
Microsoft SharePoint Foundation Incoming E-Mail
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
PerfPoint just needs secure store and PerformancePoint services.  But that doesn't mean you should disable everything else.
Cyber ITEngineer

Author

Commented:
Understood.

I have majority of the other services running on an existing WFE. I just created a new WFE to host: PerformanPoint Services, SQL Reporting Services Server, and Reporting Services Add-in.

I dont think I need the other services running on both WFEs.  
Cyber ITEngineer

Author

Commented:
Being that we are discussing PerformancePoint and Secure Store Service ... I have an issue!

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

Commented:
Honestly this should be another question in the forum.  
Cyber ITEngineer

Author

Commented:
Will do.  I broke it up into two.  Thanks!
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Do you still need this ticket open?  If not, please award points.
Cyber ITEngineer

Author

Commented:
Being that this question was about how to start/stop services manually and I ended up detaching WFE from farm and re-attaching WFE to fix the issue ... I guess we can close it out.
Cyber ITEngineer

Author

Commented:
I ended up detaching the WFE from the farm and reattaching it. The starting/stopping all seems to work well now.  The selected questions from Expert are some that helped me better understand Powershell.

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