Solved

User Mapping not "Sticking"

Posted on 2009-05-18
4
437 Views
Last Modified: 2012-05-07
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
Comment
Question by:tbaseflug
  • 2
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24417790
It sounds like a user error.  Can you give us a step by step?  Have you created the Logins?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 24417795
0
 

Author Comment

by:tbaseflug
ID: 24423611
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
 

Author Comment

by:tbaseflug
ID: 24423877
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

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question