I posted my solution to what I think is similar to your situation here: Grant Permission to SQL application database

Basically, give permissions through SSMS > [DatabaseName] > Security > Users > Create Users...

Pick the domain user

Pick Securables and set the permissions like SELECT, UPDATE, for the user to the database.