SQL Management Pack - login to databases required? RRS feed

  • Question

  • I've recently imported the SQL Management Packs (version and discovery has been working fine - Databases are being discovered and displayed in the Databases view in the SCOM console. On one of the 2012R2 SQL servers, I noticed these errors in the OpsMgr Event Log (see below)

    The information that the MP needs for the Database properties (DB Free space, source log shipping, etc.) seems like it could be achieved without having to login to each individual database. Is there a reason why the SQL MP requires this type of intrusive mechanism for querying information? Is there a way to disable these login scripts but still obtain the information about databases?

    Thursday, February 26, 2015 6:27 PM


All replies