Software Metering report is blank in SCCM

Bhagyasree Balasubramanian 0 Reputation points
2023-03-31T16:02:48.2166667+00:00

Getting an error :Could not get a SQL connection to database: CM_CM1 when trying to run the runmetersumm.exe from powershell.

SCCM Site Server and SQL DB is in different Servers.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,826 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 41,371 Reputation points Microsoft Vendor
    2023-04-03T02:29:02.7833333+00:00

    Hi, @Bhagyasree Balasubramanian

    Thank you for posting in Microsoft Q&A forum.

    If our SCCM Site Server and SQL DB is in different Servers, we need to run runmetersumm.exe from the DB server.


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".


  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  3. Alejandro Hermosilla Pizarro 0 Reputation points
    2023-08-30T16:32:13.8033333+00:00
    Hi, however the runmetersumm file is not found on the database server.
    
    0 comments No comments