License Assessment Reason Does Not Make Sense

[WStephans]

I have come across several MS SQL servers where Flexera is applying both a SQL Server Enterprise and a SQL Server Standard license to the same device (i.e. double licensing it). This occurs when the server has multiple SQL Server applications installed such as SQL Server Reporting Services & SQL Server Enterprise (SSRS being primary on the SQL Standard license and supplementary on the SQL Enterprise license). I have checked the License Assessment details and the Assessment Reason often states 'Allocation of a license entitlement to this device triggers automatic consumption'. However, no allocation exists to either license so this cannot be true. Does anyone know why this assessment reason would be displayed when no allocation exists?

[AustinG]

Hi there; your question would best be addressed with a support case. I've created a case for you based on this post. 

Cheers,

AustinG

[RWG2022]

Hi,

Did you ever get this resolved? The exact same thing is happening to me when a single VM is consuming multiple SQL Server licenses.

Thanks

[WStephans]

@RWG2022 - I just went back through my old cases and couldn't find the case unfortunately. I don't recall a solution off the top of my head. I would submit your own case with them.

[RWG2022]

That's what I've done. Thanks for checking anyway 🙂

[Nico_Erasmus]

Hi @RWG2022 and @WStephans .  

I can't comment on the assessment reason as I have never seen this.  In 12 years working with Flexera, I have not managed to get two SQL licenses to consume against the same device.

You appear to have an evidence issue or a license configuration issue.

1. SQL Enterprise License can downgrade to std - sure it is wasteful, but it take care of different editions on a cluster
2. SQL server enterprise and standard (full application recognition) take precedence over the presence of any of the RAIN components

[RWG2022]

I've logged a support ticket. Licenses were created using SKUs so product use rights should have been automatically set. This VM is licensed at the VM host level (SQL Cluster) with Enterprise Core licenses with SA. I can see the SQL Enterprise 2022 installation on the VM is being covered by this, but the VM also also has SQL Server Integration Services 2014 installed, and that is consuming SQL Server Standard Core licenses with SA. This shouldn't be the case as you can have unlimited instances of SQL Servers and its components on the same device. It is also happening with other VMs licensed per VM where it is consuming multiple licenses. Really can't get my head around why it is happening. Will wait for support to reach out.

[Nico_Erasmus]

@RWG2022 Please do not blindly trust SKU's.  Always understand the vendor products you are working with and have an expectation of results.  

[RWG2022]

We don't. We always check the product use rights and rules that have been set when a SKU has been purchased. They seem correct for the SQL licenses.