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

15 comments:

CIIT Noida said...

CIITN is the best SAP training and placement Institute in noida. Contestant will analyze in keeping with modern-day enterprise trends by way of certified and industry experts & SAP training Institute in Noida. They provide a 100% placement help with the best training of IT cousrses.

If you are looking best sap training in Noida then you can join CIITN. One of the premier training and development institute for SAP Training Program in Noida. The company provides 6 weeks/ 6 Months Training for SAP. They provide training in all SAP Modules like SAP HANA,SAP B1, SAP FICO etc. Just come for free demo class and then join SAP and move up in your career .

SAP Training Institute in Noida
sap training in noida
sap institute in noida
sap course in noida
best sap training institute in noida

rohit pal said...




Webtrackker is one only IT company who will provide you best class training with real time working on marketing from last 4 to 8 Years Experience Employee. We make you like a strong technically sound employee with our best class training.


WEBTRACKKER TECHNOLOGY (P) LTD.
C - 67, sector- 63, Noida, India.
F -1 Sector 3 (Near Sector 16 metro station) Noida, India.
+91 - 8802820025
0120-433-0760



Best SAS Training Institute in delhi

SAS Training in Delhi

SAS Training center in Delhi

Best Sap Training Institute in delhi

Best Sap Training center in delhi


Sap Training in delhi

Best Software Testing Training Institute in delhi

Software Testing Training in delhi

Software Testing Training center in delhi


Best Salesforce Training Institute in delhi


Salesforce Training in delhi

Salesforce Training center in delhi

Best Python Training Institute in delhi

Python Training in delhi

Best Python Training center in delhi

Best Android Training Institute In delhi

Android Training In delhi

best Android Training center In delhi

rajatwebtrackker said...

Hello friends, my name is Rajat and I work as the head of digital marketing in Delhi. I am affiliated with many MNC’s Software developers. If you are talking about the best educational institution in Delhi,Webtrackker help me get the best educational institute in Delhi.we are you offering some best services in our institute.with 100% job offers are available .


Best Php Training Institute in Delhi
Php Training in delhi
php Training center in delhi

Best Java Training Institute in delhi
Best Java Training in delhi
java Training center in delhi

linux Training center in delhi
Best linux Training Institute in Delhi
linux Training in delhi

Web Designing Training center in delhi
Best Web Designing Training institute in delhi
Web Designing Training in delhi

Oracle Training Institute in delhi
Oracle Training in Delhi
Oracle Training center in Delhi

blue prism Training Institute in delhi
blue prism Training in Delhi
blue prism Training center in Delhi

Automation Anywhere Training center In delhi
Automation Anywhere Training Institute In delhi

rpa Training Institute in delhi
rpa Training in Delhi
rpa Training center in Delhi

hadoop Training center in delhi
Best hadoop Training institute in delhi
hadoop Training in delhi

Blue prism training in chennai said...

Robotic Process Automation provides organizations like yours with an agile digital workforce that follows rule-based business processes and interacts with the systems in the same way that existing users currently do. Blue Prism enables this, but in a way that is far more efficient. It’s also secure, consistent, reliable and scalable. Importantly Blue Prism complements traditional IT solutions such as BPM and front office productivity tools. It provides a universal and consistent back office automation platform with embedded controls and governance that is code-free and managed by the organization itself.Blue Prism Training in Chennai

svr said...

Quite helpful! good job!Thanks for sharing the information.Keep updating good stuff...
sap abap developer training

Pankaj Singh said...

Wow, Nice blog. Thank you so much for the efforts of this blog. Visit for
Europe Honeymoon Packages

Riya Raj said...

The blog you have shared is more informative... Thanks for your valid blog.
Selenium Training in Bangalore
Selenium Training in Coimbatore
Best Selenium Training Institute in Bangalore
best selenium training in coimbatore
RPA training in bangalore
Selenium Training in Bangalore
Java Training in Madurai
Oracle Training in Coimbatore
PHP Training in Coimbatore

lekha mathan said...

Useful Information!!!...Thank You
Aviation Courses in Chennai
air hostess academy in Chennai
Airport management courses in Chennai
Airport Management Training in Chennai
medical coding in Chennai
top 10 fashion designing colleges in Chennai
interior design courses in Chennai part time

sudhagar said...

Thanks to the admin you have spend a lot for this blog I gained some useful info for you. Keep doing.
Digital Marketing Training in Chennai
Digital Marketing Course in Chennai
Cloud Computing Courses in Chennai
AWS Training in Chennai
Data Science Course in Chennai
Digital Marketing Training in Tambaram
Digital Marketing Training in OMR
Digital Marketing Training in Adyar

Anbarasan14 said...

An extremely informative and interesting blog among all you have shared. Update it frequently.

Spoken English Classes in Perambur
Spoken English Classes in Anna Nagar West
Spoken English in Porur
Spoken English Classes in Chennai Poonamallee
Spoken English Class in Kodambakkam
Spoken English in Valasaravakkam
Spoken English Class in Triplicane
Spoken English in Adyar

yuva rani said...

I am really enjoying reading your well written articles.
It looks like you spend a lot of effort and time on your blog.
I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..
Cloud Computing Courses in Chennai
Cloud Computing Training in Chennai
AWS Training in Chennai
Data Science Course in Chennai
Digital Marketing Course in Chennai
Cloud Computing Training in Anna Nagar
Cloud Computing Courses in Adyar

alex said...

Let's play together on the website of the online casino BGAOC. great gambling sites Do not miss the chance to win with us.

sheela rajesh said...

Thank you for giving the opportunity to read this like an informative blog.
i really appreciate you for your great work.
Loadrunner Training in Chennai
French Classes in Chennai
Big Data Training in Chennai
Hadoop Training in Chennai
Android Training in Chennai
Digital Marketing Course in Chennai
German Courses in Chennai
German Classes in Chennai
German classes in Velachery

ajay prakash said...

I read the post and I have really enjoyed your blogs posts. Looking for the next post.
Aviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
Medical coding training in Chennai
Fashion designing courses in Chennai
Interior design courses in Chennai

Durai Raj said...

Great information!!! The way of conveying is good enough… Thanks for it
PHP Training in Coimbatore
php training institute in coimbatore
Java Training in Bangalore
Python Training in Bangalore
IELTS Coaching in Madurai
IELTS Coaching in Coimbatore

Java Training in Coimbatore