Limit number of user logins in SQL Server
Logon triggers are special. Not going too far into it, they must exist in the master database and not any other, thus the answer to your question is: "It can't."

https://msdn.microsoft.com/en-us/library/bb326598.aspx

-Sean