SCCM Console not connecting to the database


We have recently allowed a few more people to utilise some of the functionality that the SCCM Console offers and installed the console onto their machines (albeit with heavily restricted permissions and they have to pass a training session first!!).

However, a few of the machines were receiving the error that they could not connect to the SCCM database as per below:

SCCM Console not connecting to the database 1

If you are an SCCM administrator, the chances are that you are very familiar with this error page and most of the time a tweak of permissions is all it takes to fix it.

So, I checked permissions and fixed some errors, but still three machines had this problem and I couldn’t seem to find out why as everything did look ok. I checked the WMI, DCOM, update to CU1 and all seemed to be correct.

How to fix the console error

This then took me to the SMSAdminUI.log file usually located in this directory:

C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\AdminUILog

When I looked in here I had on all three machines the following errors:

The performance counter ‘# result objects in memory’ was not found

The performance counter ‘# exceptions’ was not found

The performance counter ‘# images’ was not found

This lead me to believe that the performance counter was corrupt. So, to fix this, I fully uninstalled the SCCM Console, once uninstalled, I run the following command on the affected machine:


Once complete, you should get a message as per below:

SCCM Console not connecting to the database 2

You should now re-install the SCCM Console and apply any necessary hotfixes (i.e. CU1) and you should now find that your console will open successfully.


If you have any feedback on this guide, please feel free to leave us a message below in our comments section.

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Recommended...  Java Updates to Client Machines using Windows Updates

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

4 thoughts on “SCCM Console not connecting to the database”

Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.