"SQL Azure does not meet minimum requirements" during installation

  • 15 February 2022
  • 0 replies
  • 11 views

Badge +3
 

"SQL Azure does not meet minimum requirements" during installation

KBS100132

PRODUCT
K2 Five 5.1
BASED ON
K2 Five 5.1
TAGS
Installation
SQL
Troubleshooting Document
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Issue

When installing K2 5.1, you may experience this issue with the following error appearing: 

 

Image

Symptoms

The minimum installation requirements for SQL Azure Database Service Tier is the following:

https://help.k2.com/k2compatibilitysupportmatrix#SQLServer

 

"Azure SQL S2 is required at a minimum. K2 recommends Azure SQL P1, however this may vary depending on the estimated use."

 

This warning message will pop-up during your installation and it will not allow you continue any further.

Troubleshooting Steps

To confirm what Azure SQL Database Service Tier you have on your environment, please refer to this article:

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-service-objectives-azure-sql-database?view=azuresqldb-current

 

Run this query against your K2 Database:

 

SELECT slo.service_objective FROM sys.databases d
JOIN sys.database_service_objectives slo
ON d.database_id = slo.database_id;

 

It will return the relevant Service Tier.

 

If it returns ElasticPool, it means you are not running a supported Tier with K2. To be on a supported Service Tier, it needs to return a minimum of S2, but a preferred Tier would be P1.


0 replies

Be the first to reply!

Reply