Identifying if SCCM is running on SQL evaluation version

Identifying if SCCM is running on SQL evaluation version

Today I will take a look on how we detect if our SCCM installation is running on a SQL 2012 evaluation version.

The first thing we will have to do is to start SQL Server Management Studio:

image

Connect to the server.

image

Right click on the SQL server name and select properties:

image

In Product you will see the word Evaluation if this is an Evaluation version:

image

Now that we know this is actually an evaluation version, we can see when it will expire, using this query:

SELECT create_date AS ‘Install Date’,DATEADD(DD, 180, create_date) AS ‘Expiry Date’ FROM sys.server_principals WHERE name = ‘NT AUTHORITYSYSTEM’

image

Table of Contents

Share this post
Search blog posts
Authors
Modern Workplace consultant and a Microsoft MVP in Enterprise Mobility.
Modern Workplace consultant and a Microsoft MVP in Windows and Devices for IT.

Infrastructure architect with focus on Modern Workplace and Microsoft 365 security.

Passionate IT professional with 20+ experience in IT architecture, consulting, and design. 

Cloud & security specialist with focus on Microsoft backend products and cloud technologies.

Infrastructure architect with focus on design, implementation, migration and consolidation.

Infrastructure consultant with focus on cloud solutions in Office365 and Azure.

follow us in feedly
Categories

Follow on SoMe