Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

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"?
0
tbaseflug
Asked:
tbaseflug
  • 2
  • 2
1 Solution
 
Anthony PerkinsCommented:
It sounds like a user error.  Can you give us a step by step?  Have you created the Logins?
0
 
Anthony PerkinsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now