You can follow below steps to check the active connections of MSSQL database.
Login to Windows server.
Open SQL Management studio.
Here right click on particular database and click on execute.
Now you have to run the select query to check active database connection.
SELECT DB_NAME(dbid) AS...