Friday 7 September 2012

SCOM Data Access Service Fails to Start

I was speaking to an old colleague the other day who is in the middle of migrating his production Operations Manager 2007 R2 environment to a nice new shiny 2012 setup.

Things were initially going well but he explained that he ran into a rather strange issue just after migrating the first batch of agents across to just talk to his live 2012 infrastructure, what made it stranger was these had been talking to his test infrastructure (dual homed) fine for quite a while.

When he moved them across, shortly after, the System Center Data Access service stopped and refused to start.

No matter what he tried it wouldn't work and he had to fall back to restoring a backup.

This left him a little hesitant about the stability of his live environment and whether something wasn't quite right underneath it all somewhere, but it seemed to be fine after the restore so he thought he'd see how it went.

Well the same problem reared it's ugly head again the other day so he did some more digging.

Eventually he stumbled across this post from Travis Wright explaining an issue seen in Service Manager.
http://blogs.technet.com/b/servicemanager/archive/2011/10/04/system-center-data-access-service-start-up-failure-due-to-sql-configuration-change.aspx

Since Service Manager and Operations Manager share the same code base and the problem described is essentially a SQL problem anyway he took a look to see if it was indeed the same issue affecting him, turns out it was!

It finally turned out to be something one of the developers were doing with custom reports and scheduling that was adding a local SQL account to the security roles as DBOwner (Dev to be taken outside and shot...)

So in summary, if you're using SCOM and your System Center Data Access Service refuses to start and you're seeing event log errors such as:
  • 26325 Authorization store exception
  • 26339 Exception thrown while initializing the service container
  • 26380 Unhandled Exception
then take a look at the Service Manager blog link above and check your SQL security logins to see if something/someone is flipping the Authentication mode to Mixed-Mode.

Good find Rob, now get your blog back online and start sharing things like this again ;)

30 comments:

Manipriyan said...
This comment has been removed by the author.
Sivanandhana Girish said...

Thanks for sharing this information with us. The content was helpful to many of the readers.
Education Franchise India
Spoken English Franchise
Franchise For Spoken English Classes
Top Education Franchise In India
Best Education Franchise In India
Computer Education Franchise
Education Franchise India
Computer Center Franchise
Education Franchise Opportunities In India

Anonymous said...

Nice post, Thank you for sharing valuable information. I enjoyed reading this post. Please Feel Free to Visit
Ooty travels | Ooty cabs

Benish said...

Nice post...Thanks for sharing..
Python training in Chennai
Python training in OMR
Python training in Velachery
Python certification training in Chennai
Python training fees in Chennai
Python training with placement in Chennai
Python training in Chennai with Placement
Python course in Chennai
Python Certification course in Chennai
Python online training in Chennai
Python training in Chennai Quora
Best Python Training in Chennai
Best Python training in OMR
Best Python training in Velachery
Best Python course in Chennai

Jackie Co Kad said...

Great Article
Final Year Project Domains for CSE
Final Year Project Centers in Chennai





JavaScript Training in Chennai
JavaScript Training in Chennai

Vijiaajith said...

Good blog, keep posting
freeinplanttrainingcourseforECEstudents
internship-in-chennai-for-bsc
inplant-training-for-automobile-engineering-students
freeinplanttrainingfor-ECEstudents-in-chennai
internship-for-cse-students-in-bsnl
application-for-industrial-training

OGEN Infosystem (P) Limited said...

Thank you so much for this useful article. Visit OGEN Infosystem for Web Designing and SEO Services in Delhi, India.
Best Website Designing Company in India

FWD Soft Solution said...

Awsome! I really injoy and inspired with reading it. This post is very constructive produced by you.
website designing company in faridabad
Website development company in faridabad
Digital Marketing Company in Faridabad

sasi said...


I have to agree with everything in this post. Thanks for useful sharing information.
Hadoop Training in Chennai
Hadoop Training in Bangalore
Big Data Course in Coimbatore
Big data course in bangalore
Big Data Course in Chennai
Big Data Training in Bangalore
Python Training in Bangalore
salesforce training in bangalore
hadoop training in marathahalli
hadoop training in btm

subha said...

For my view is Really nice,because all peoples are giving the wonderful comments
battlesteed..good page
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai

Janu said...

Good job in presenting the correct content with the clear explanation. The content looks real with valid information. Good Work


Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery


Village Talkies said...

Best Corporate Video Production Company in Bangalore and top Explainer Video Company in Bangalore , 3d, 2d Animation Video Makers in Chennai.
Many many thanks for sharing such valuable tips. we really appreciate your nice explanation.

travel5212 said...


Amazing Article,Really useful information to all So, I hope you will share more information to be check and share here.thanks for sharing .
Website: Vietnam Tour Packages

ashi123 said...

I always like to read a quality content having accurate information regarding the subject and the same thing I found in this post. Nice work
GST Registration | Trademark Registration

Ali jan said...

Threats to your Salesforce Data Integrity can come from any direction. It might seem that the process runs smoothly, yet errors can be introduced from various area. However, the concerned areas include the following: Salesforce interview questions and answers

siva said...

Such a great blog, thanks for sharing the blog.
ielts preparation tips
how to become an ethical hacker
stress interview questions
how much java is required for selenium
ethical hacking interview questions

Pathway for German Language said...
This comment has been removed by the author.
John said...


Threats to your Salesforce Data Integrity can come from any direction. It might seem that the process runs smoothly, yet errors can be introduced from various area. However, the concerned areas include the following: Salesforce interview questions and answers
سیاوش قمیشی

شادمهر عقیلی

افشین

David Smith said...

Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
Visit here :- Seo Company In Gwalior

Punjabstatelottery said...

it is really a great and helpful piece of info. I am glad that you shared this helpful information with us. Please keep us informed like this. Thank you for sharing.
Website: Punjab state lottery

ve may bay tet said...

Đặt vé máy bay tại Aivivu, tham khảo

vé máy bay đi Mỹ giá rẻ

mua vé máy bay về vn từ mỹ

lịch bay từ anh về việt nam hôm nay

chuyến bay từ pháp về việt nam hôm nay

buyonline123 said...

I am really enjoying reading your well written articles. I think you spend numerous effort and time updating your blog.
online electronics shopping sites in india

Ganesh said...

Amazing..! I was impressed by your great post and Keep doing well...
Microsoft Dynamics CRM Training in Chennai
Node JS Training in Chennai
Node JS Course in Chennai

Magesh said...

Most helpful blog! It is the greatest comprehensive updates about this topic and Thank you for your sharing with us..!
Automation Anywhere Training in Chennai
Automation Anywhere Online Training
VMware Training in Chennai
VMware Course in Bangalore
Automation Anyware Online Course

Mega said...

This information is very interesting to read. Thanks for updating.
convert list into string in python
convert list into string in python

thomas said...

Rather than accept this fee as a cost of doing business, government agencies pass it along, Wood says.

fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com
fishyfacts4u.com

thomas said...

However, there are options to upgrade your account for more storage space and the ability to connect your own domain. There are two options available – the Basic plan and the Unleashed plan, which both unlock Google Analytics and Facebook pixel integration features among other goodies. See the Zyro pricing plans for more details.

emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com
emagazinehub.com

thomas said...

“It can often be worth making a call to your credit card issuer to see if you can get a fee waived either permanently or for a short time,” says Matt Schulz, chief industry analyst at CompareCards.com. “The credit card marketplace is so competitive, your chance of success is probably higher than you realize.”

inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com
inewshunter.com

thomas said...

However, be aware that expenses paid for with a DCFSA are not eligible for a child and dependent care tax credit. What's more, money deposited in a flexible spending account typically must be used that same year or be forfeited.

juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com
juicyfactor.com

thomas said...

Greene-Lewis says that even if you don't receive 1099s, "it's important to keep careful records and track all income under these limits as you still need to report all income regardless of whether or not you received the forms."

localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com
localnewsbuzz.com