I have the same problem, solidcp 1.41, does not validate the number of SQL Server databases and allows unlimited creation

Please try to upgrade SolidCP to the latest 1.4.2, it will fix the issue

yes.. fixed!!! .. thanks you.

I know this is an older thread, however I ran into this exact issue with SolidCP version 1.4.4

The issue appears to be in the Quotas table in reference to the ItemTypeId of Sql2016 databases and users.  I fixed it by updating the values to the correct ones by doing the following:

DECLARE @dbTypeId int
DECLARE @userTypeId int
DECLARE @dbQuotaId int
DECLARE @userQuotaId int
SET @dbTypeId = (SELECT ItemTypeId FROM ServiceItemTypes WHERE DisplayName = 'MsSQL2016Database')
SET @userTypeId = (SELECT ItemTypeId FROM ServiceItemTypes WHERE DisplayName = 'MsSQL2016User')
SET @dbQuotaId = (SELECT QuotaId FROM Quotas WHERE QuotaName = N'MsSQL2016.Databases')
SET @userQuotaId = (SELECT QuotaId FROM Quotas WHERE QuotaName = N'MsSQL2016.Users')
UPDATE Quotas SET ItemTypeID = @dbTypeId WHERE QuotaID = @dbQuotaId AND QuotaName = N'MsSQL2016.Databases'
UPDATE Quotas SET ItemTypeID = @userTypeId WHERE QuotaID = @userQuotaId AND QuotaName = N'MsSQL2016.Users'

Hello,

Can you please show me your quota table with the changes you made? We can then look to fix this in the SQL code for future issues.

Regards,

Trevor