I am using sqlcmd to create a login and user and I still get unable to login.
These are my steps:
create login user1 with password = 'user1pw'
create user user1 for login user1
sp_addrolemember 'db_datareader', 'user1'
Password: Password: Msg 18456, Level 14, State 1, Server MSSQLSVR, Line 1
Login failed for user 'user1'.