(SSRS) SQL Server Reporting Service EVAL mode check

Bushbaker27 21 Reputation points
2022-09-12T17:03:31.43+00:00

I'm programmatically making a preemptive check for SSRS, specifically checking if it was installed in EVAL/Evaluation mode.

Where would this value be stored in the installation folders? I am using powershell to accomplish this and have been told this command would help me parse out the needed information:

Get-WmiObject -namespace "C:\Microsoft\SqlServer\ReportServer\RS_SSRS\V15" -class MSReportServer_Instance | Select-Object -Property EditionName, Version, InstanceName  

Unfortunately, that path doesn't seem to hold anything. I verified that SSRS is indeed installed and working. I'll need the paths for the 2019 and 2017 versions.

Background:
Sometimes client installs will be configured in EVAL mode and 6 months after initial installation, their reporting server will stop working because of this. I want to make a preemptive check that will ensure that SSRS is not in EVAL mode. This will be implemented into a script that checks many environment variables, ensuring they are configured correctly.

Thanks!

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,911 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,504 questions
0 comments No comments
{count} votes

Accepted answer
  1. Rich Matheisen 46,551 Reputation points
    2022-09-12T18:25:57.69+00:00

    The WMI namespace isn't a file path. :-)

    Change the "C:" to "root\" and try again.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.