Issue

On Deployment the below error occurs:

"A database error occurred : Could not allocate space for object 'Server.Assembly'.PK_Server_Assembly in database K2Dev'"

Image

Symptoms

The solution fails on deployment because the K2 Database is 4GB and SQL Express has a limitation of 4GB.

Resolution

To upgrade the SQL instance

Microsoft SQL Server comes in different versions that includes

  • SQL Server Enterprise
  • SQL Server Business Intelligence
  • SQL Server Standard
  • SQL Server Web
  • SQL Server Express

SQL Express has a limitation on space allocation and it is suggested to use SQL Enterprise without any space limitations.