Solved

User Mapping not "Sticking"

Posted on 2009-05-18
4
430 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 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