Users are generated in the database, whereas logins are established on the server. In other words, a login allows you to connect to a SQL Server service (also known as an instance), but database users, not logins, have permissions inside the database.