Become a member
Sign in
Hi again Ioan, I have a few SCCM servers here (long story).
2
Greg Heywood
Greg Heywood
Greg Heywood
Sep 8, 2018 · 1 min read

Fixed it. :)

This page (http://eskonr.com/2013/09/sccm-configmgr-sql-errorthe-select-permission-was-denied-on-the-object-database-cm_sitecode-schema-dbo/) talked about using sp_who2, so I was able to see that a particular account was being used that didn’t have permissions on those views for some reason. I added it manually, and all works!

    Greg Heywood

    Written by

    Greg Heywood

    Write the first response

    Discover Medium

    Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

    Make Medium yours

    Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

    Become a member

    Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade
    AboutHelpLegal