SharePoint 2010 related service gets disabled every hour

Today I was facing several PowerPivot workbooks that could not refresh data in a virtualized environment. After checking the database hosting the data and couldn't find any permission or connectivity issues I turned to Analysis Services. I checked and the SQL Server Analysis Services service was disabled. No problem. I set it to Automatic startup and started the service. It was working like a charm but after a while I got the same error as before. I went back and noticed that the service is disabled again. I enabled it again but after a while it was disabled again. What I noticed was that it got disabled every hour. I googled for the problem and found an article here, where the same thing happened with the Project Server Queue Service. It turned out that the SP Health rule "One or more services have started or stopped unexpectedly" due to a bug disables random services at the hourly run. The only fix for this issue is to disable the automatic repair functionality of this rule.

For me it solved the issue.

Comments (6) -

Alease Stinett
Alease Stinett
8/5/2013 3:17:06 AM #

Hello, I enjoy your weblog. Is there something I can do to receive updates like a subscription or something? I'm sorry I am not familiar with RSS?

Porsche Mashore
Porsche Mashore
8/7/2013 2:34:17 AM #

Really wonderful site thank you so much for your time in publishing the posts for all of us to learn about.

Kristen Clucas
Kristen Clucas
10/22/2013 11:33:07 PM #

Hey this is a good looking site, is wordpress? Forgive me for the foolish question  but if so, what theme is? Thanks!

Janiece Riebow
Janiece Riebow
10/22/2013 11:35:44 PM #

You've got a wonderful weblog here! would you like to create some invite posts on my website?

Obdulia Tjelmeland
Obdulia Tjelmeland
10/23/2013 12:06:48 AM #

Hey this is a good looking site, is wordpress? Forgive me for the foolish question  but if so, what theme is? Thanks!

Dewey Grandt
Dewey Grandt
10/27/2013 3:42:20 AM #

Hallo Robotnik, ich war in Lippstadt, im tiefsten Westfalen, ein herrlicher Ort zum Entspannen und zum Shoppen. Aber jetzt gehts hier wieder weiter, einen guten Rutsch wünscht<br />Claus

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

About the author

Hi! I'm Marcell Mikolcsó, SharePoint and Enterprise Administrator, System Architect.

Month List

Page List