Ensure that the SQL Server is running and configured correctly, and try the operation again. ID: 2604

Yesterday morning I tried to login to SCVMM 2012R2 and I got below error. I logged it to MSSQL server over SQL Management studio to check out if availability groups are fine. After around 10 minutes of investigation I found out LOG partition on SQL server run out of free space. I had to extend LOG virtual disk drive, extend LOG partition on MSSQL server and restart SCVMM services to make it working again.

Database operation failed. Ensure that the SQL Server is running and configured correctly, and try the operation again. ID: 2604

If you are wondering how to extend virtual disk on Hyper-V 2012 R2 click on this link

Artur Krzywdzinski

Artur is Consulting Architect at Nutanix. He has been using, designing and deploying VMware based solutions since 2005 and Microsoft since 2012. He specialize in designing and implementing private and hybrid cloud solution based on VMware and Microsoft software stacks, datacenter migrations and transformation, disaster avoidance. Artur has been in IT industry since 1999 and consulting since 2008. Artur holds VMware Certified Design Expert certification (VCDX #077).