Here's how to determine who is connected to your SQL.

This is very helpful if you are moving your SharePoint from one SQL Instance to another

Steps:

  1. Open up SQL Server Management Studio.
  2. Execute a new query, type SP_Who and then run or execute the query.