How to fix SQL72014: Framework Microsoft SqlClient Data Provider: ALTER DATABASE failed because a lock could not be placed on database

Error

SQL72014: Framework Microsoft SqlClient Data Provider: ALTER DATABASE failed because a lock could not be placed on database

Solution

Clear all transactions and locks on database server:

USE master;
GO
ALTER DATABASE [InsightDictionary] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [InsightDictionary] SET MULTI_USER;

Tested on Microsoft SQL Server 2022 Developer Edition.