MSSQL How To find the active connections to the database. (system or users)

In MSSQL the SQL management console has many robust features. To find the active connections please feel free to follow the information below.

Step-by-step guide

Microsoft - Monitoring with SQL Server Management Studio
1. Multiple solutions.
  Use SQL Server Management Studio to view the following information about current SQL Server activity:
  - Current user connections and locks.
  - Process number, status, locks, and commands that active users are running.
  - Objects that are locked, and the kinds of locks that are present.
  If you are a system administrator, you can view additional information about a selected process, or terminate a selected process.
  You can view activity on an instance of SQL Server in the following ways:
  - Activity Monitor
    Use the Activity Monitor in SQL Server Management Studio to perform ad hoc monitoring of an instance of SQL Server. This enables you to determine, at a glance, the volume and general types of activity on the system, for example:
    - Current blocked and blocking transactions.
    - Currently connected users on an instance of SQL Server, and the last statement executed.
    - Locks that are in effect.
Microsoft How to for many different ways to show the active connections. (Click for more details)