View Current Connections

You can use the sys.dm_exec_connections dynamic management view to retrieve information about current connections to the SQL Server instance.

SELECT * FROM sys.dm_exec_connections;