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 ;)

49 comments:

Manipriyan said...
This comment has been removed by the author.
Malaivel Siddha Hospital said...

Wow, what an awesome spot to spend hours and hours! It's beautiful and I'm also surprised that you had it all to yourselves!
Kindly visit us @
Best HIV Treatment in India
Top HIV Hospital in India
HIV AIDS Treatment in Mumbai
HIV Specialist in Bangalore
HIV Positive Treatment in India
Medicine for AIDS in India
Cure best blood cancer treatment in Tamilnadu
HIV/AIDS Complete cure for siddha in Tamilnadu
HIV/AIDS Complete cure test result in Tamilnadu
AIDS cure 100% for siddha in Tamilnadu

Shanthi Cabs said...

The article is very interesting and very understood to be read, may be useful for the people. I wanted to thank you for this great read!! I definitely enjoyed every little bit of it. I have to bookmarked to check out new stuff on your post. Thanks for sharing the information keep updating, looking forward for more posts..
Kindly visit us @
Madurai Travels | Travels in Madurai
Best Travels in Madurai
Cabs in Madurai | Madurai Cabs
Tours and Travels in Madurai

KIT said...

Nice blog, it's so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.
Kindly visit us @ 100% Job Placement | Best Colleges for Computer Engineering
Biomedical Engineering Colleges in Coimbatore | Best Biotechnology Colleges in Tamilnadu
Biotechnology Colleges in Coimbatore | Biotechnology Courses in Coimbatore
Best MCA Colleges in Tamilnadu | Best MBA Colleges in Coimbatore
Engineering Courses in Tamilnadu | Engg Colleges in Coimbatore

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

Aruna Ram said...

Great article and it is very inspiring to me. I glad to satisfy with your good job. You put the effort is very superb and I always appreciate your unique information. Keep it up.
Pega Training in Chennai
Pega Course in Chennai
Excel Training in Chennai
Corporate Training in Chennai
Embedded System Course Chennai
Linux Training in Chennai
Spark Training in Chennai
Tableau Training in Chennai
Pega Training in Tambaram
Pega Training in Porur

Venkatesh CS said...

Excellent Blog. Thank you so much for sharing.
best react js training in Chennai
react js training in Chennai
react js workshop in Chennai
react js courses in Chennai
react js training institute in Chennai
reactjs training Chennai
react js online training
react js online training india
react js course content
react js training courses
react js course syllabus
react js training
react js certification in chennai
best react js training

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

easylearn said...

Hi,
Good job & thank you very much for the new information, i learned something new. Very well written. It was sooo good to read and usefull to improve knowledge. Who want to learn this information most helpful. One who wanted to learn this technology IT employees will always suggest you big data hadoop training in bangalore. Because big data hadoop course in Bangalore is one of the best that one can do while choosing the course.

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

saathvik kutta said...

This is good information and really helpful for the people who need information about this.
personalized mugs online india
print cup online india
rent laptop chennai
computer rental in chennai
company registration consultants in chennai
private limited company registration 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

Vijiaajith said...

good
interview-questions/aptitude/permutation-and-combination/how-many-groups-of-6-persons-can-be-formed

tutorials/oracle/oracle-delete

technology/chrome-flags-complete-guide-enhance-browsing-experience/

interview-questions/aptitude/time-and-work/a-alone-can-do-1-4-of-the-work-in-2-days


interview-questions/programming/recursion-and-iteration/integer-a-40-b-35-c-20-d-10-comment-about-the-output-of-the-following-two-statements

Venkatesh CS said...

Thanks for sharing valuable information.
Digital Marketing training Course in chennai
digital marketing training institute in chennai
digital marketing training in Chennai
digital marketing course in Chennai
digital marketing course training in omr
digital marketing certification in omr
digital marketing course training in velachery
digital marketing training center in chennai
digital marketing courses with placement in chennai
digital marketing certification in chennai
digital marketing institute in Chennai
digital marketing certification course in Chennai
digital marketing course training in Chennai
Digital Marketing course in Chennai with placement
digital marketing courses in chennai

Pankaj Singh 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

KIT said...

A very interesting blog....

Pradeep Appslure said...

Mobile app development company in mumbai

Shanthi Cabs said...

Nice blog, it’s so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.

jeewangarg said...

Wow!!! It was really an Informational Article which provide me with much Insightful Information. I would like to first thank the author for such an Insightful Content. If someone here is looking for a Website Designing Company in India, then look no further than Jeewangarg.com as we are the best website designing company in Delhi working in the arena for the last 8 years.
Best website designing company in India
website designing company in Delhi NCR
Google Partner in India

Video Production Company said...

Well I definitely enjoyed reading it. This tip procured by you is very constructive for correct planning.
Video production in delhi
Corporate video production company in delhi
Corporate video production services in delhi
video production services

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

Daily Health Tips said...

Hello Admin!

Thanks for the post. It was very interesting and meaningful. I really appreciate it! Keep updating stuffs like this. If you are looking for the Advertising Agency in Chennai | Printing in Chennai , Visit Inoventic Creative Agency Today..

shreekavi said...

Great post. keep sharing such a worthy information
Software Testing Training in Chennai
Software Testing Training in Bangalore
Software Testing Training in Coimbatore
Software Testing Training in Madurai
Best Software Testing Institute in Bangalore
Software Testing Course in Bangalore
Software Testing Training Institute in Bangalore
Selenium Course in Bangalore

Shanthi Cabs said...

Keep sharing the post like this...

shalini said...

Your article is very informative. Thanks for sharing the valuable information.
DevOps Training in Chennai
DevOps Training in Bangalore
DevOps Training in Coimbatore
Best DevOps Training in Marathahalli
DevOps Training Institutes in Marathahalli
DevOps Institute in Marathahalli
DevOps Course in Marathahalli
DevOps Training in btm
DOT NET Training in Bangalore
PHP Training in Bangalore

sanjandevan said...

awesome article,the content has very informative ideas, waiting for the next update...
javascript training in chennai
javascript training in velachery
javascript training courses
javascript training classes
javascript course fees
javascript training in chennai
core java training in chennai
Photoshop Classes in Chennai
Manual Testing Training in Chennai
Drupal Training in Chennai

diyasurya said...

Interesting blog. Got a lotb of information about this technology.
Spoken English Classes in Chennai
English Coaching Classes in Chennai
IELTS Training in Chennai
Japanese Language Course in Chennai
TOEFL Training in Chennai
French Language Classes in Chennai
content writing course in chennai
spanish courses in chennai
Spoken English Classes in Porur
Spoken English Classes in Adyar

Vivek Vichu said...

Nice Blog...Thanks for sharing the article waiting for next update...
Artificial Intelligence Course in Chennai
best artificial intelligence training in chennai
C C++ Training in Chennai
javascript training in chennai
Html5 Training in Chennai
QTP Training in Chennai
Spring Training in Chennai
DOT NET Training in Chennai

SS Vermicompost Industry said...

Thanks for sharing such a great blog
Vermicompost Manufacturers | Best Vermicompost in chennai

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

rightselects said...

Wow!!! It was a great article I came to know a lot about the elevators by going through this article. If you’re also looking for a Hydraulic Passenger Lift, visit right select to gain the best possible information about the top 10 elevator companies in india.

tjproductstech said...

Hi, Very nice article. I hope you will publish again such type of post. Thank you!
Corporate gifts ideas | Corporate gifts
Corporate gifts singapore | Corporate gifts in singapore
Promotional gifts singapore | Corporate gifts wholesale Singapore

diya sri said...

Innovative blog thanks for sharing this inforamation.
German Classes in Chennai
german classes
learn Japanese in Chennai
spoken english training in chennai
Best Spoken English Class in Chennai
TOEFL Coaching Centres in Chennai
ielts institute in chennai
ielts exam coaching in chennai
content writing course in chennai
spanish coaching in chennai
German Classes in OMR
German Classes in Porur

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.

Sreyas Ram said...

nice blog..valuable information....thanks for sharing...
Study Abroad Consultants in Kerala
study abroad consultants in thrissur
Study Abroad Consultants in Calicut
abroad job consultancy in coimbatore
abroad job consultancy in thrissur
overseas education consultants in thrissur
study abroad
study in poland
study in europe
education in germany

Fashion jewellery wholesalers said...

I have read your article, it is really interesting and has lots of useful information. I also recommend it to friends so they can read it and they see the same thing.
Website Artificial Jewellery

Jagna Co Kalani said...

Great Article
Final Year Projects in Python

Python Training in Chennai

FInal Year Project Centers in Chennai

Python Training in Chennai

riya singh said...

I enjoyed over read your blog post. This was actually what i was looking for and i am glad to came here!
Website: Imitation jewellery

sattamatka 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
Website Matka Guessing Tricks

svrtechnologies said...


Firstly talking about the Blog it is providing the great information providing by you . Thanks for that .Hope More articles from you . Next i want to share some information about Salesforce training in Banglore .

centre99 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.
malaysia visa online

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

James said...

The developed models using science help forecast weather and to predict accurately the occurrences of the natural calamities too. data science course syllabus

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