Add windows user to a particular database in SQL Server
Yes, you must first create a Login on the SQL Server instance, then create a User in the database which maps to that Login.

Without a Login, the user cannot be authenticated to SQL Server (unless you're using a Contained Database, which is not a feature of your version of SQL Server), so they won't be able to access the database.