SQL Server Error 3702 is a common roadblock when attempting to drop a database that still has active connections. The error message reads:
Msg 3702, Level 16, State 4
Cannot drop database because it is currently in use.
You can quickly resolve this issue by setting Restrict Access to SINGLE_USER
Now you can see the BI_Reporting database is in Single User Mode
Now we can delete the database by right click on the database then delete or use the T-SQL DROP Database statement.
