Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-05-11 : 17:52:25
|
| Hi experts,I am trying to remove a user (domain login) from database role. I selceted role, then properties, then members. It shows members list. I selected domain user and clicked remove. user disappear from list. When I click ok. I am getting "No mapping between account names and security IDs was done. ..." message. I cannot remove login from this role. Any help. Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-11 : 21:25:01
|
| Try sp_droprolemember.If that doesn't work, go to the logins tab in the GUI and click user mapping and remove 'em there.Else, you just have an orphaned user, and can safely drop the user from the database. |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-05-12 : 11:28:52
|
| Russell, I am working in Analysis Services not database engine (ssms). I tried to run sp_droprolemember but there is error. I think I cannot run this procedure in analysis services. Any other way in analysis services? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-12 : 11:40:38
|
| I wasn't paying enough attention. Sorry. Haven't seen that before, nor am I able to reproduce it.Might click the script button on that screen and modify the script to not incluse the member in question...just a thought |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-05-12 : 12:06:46
|
| Thanks russell for your help. That works. |
|
|
|
|
|
|
No mapping between account names and security IDs