MS Operations Management Suite: SQL Assessment

I’ve manually added in a SQL 2012 server into my MSOMS service.

The assessment data was not uploaded because of permissions problems with the NT AuthoritySystem Account not having access into the SQL databases to run the assessment queries.

The log file that was used in troubleshooting is called “SironaLog_Advisor_20150527_103752” and it’s located in the These file name and locations might change with later versions.

I’ve giving this NT AuthoringSystem account read access on the different DBs as this is a lab environment, no harm no foul.

In a production environment with the SCOM management group connected you will make use of the run-as account for the SQL assessment collection

I’ve had to set the date on the SQL server forward by 7 days so that the assessment and collection will occur again.

Details when clicking on the above tile

Clicking on the “Availability and Business Continuity” above shows more in-depth information.

For each of the findings there is a Prioritization and also a Recommendation section with affected objects, context and actions on how to fix each finding.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s