Question: How can I find the number of sql server connection attempts on a SQL Server Instance since the last SQL Server restart?

Answer: According to SQL Server BOL @@connections “Returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started”

select @@connections as 'Login Attempts'

Sometimes there is confusion between user count and connections. These two are not always the same. Multi – tier applications , can open multiple connections as part of the interaction with the database server. Within one application process, it is not unusual for an application to open and close connections , either as explicit or implicit