User Mapping not "Sticking"

I am going in and mapping a network user to the db with data read/write - select all the dbs and hit OK - then go back into user mappings and nothing "sticks"?
tbaseflugAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
0
 
Anthony PerkinsCommented:
It sounds like a user error.  Can you give us a step by step?  Have you created the Logins?
0
 
tbaseflugAuthor Commented:
I just cannot get it to stick here - the users creating the DBs are set to dbcreator and security admin - and I am a SA/dbo - when I go into user mappings for the account in question - after the db is created - I see datareader/writer is set bu the "map" check box is not checked - so I check it and then hit OK - then go back in and it is unchecked again?
0
 
tbaseflugAuthor Commented:
Again - I see the datareader checked - but the mapping is not - so am getting:
Msg 916, Level 14, State 1, Line 1
The server principal "UserHere" is not able to access the database "dbHere" under the current security context.
0
All Courses

From novice to tech pro — start learning today.