Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

User Mapping not "Sticking"

Posted on 2009-05-18
4
Medium Priority
?
457 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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

885 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