Friday, July 27, 2012 10:40 PM
When I run get-spshelladmin I see several users listed, including DOMAIN\thisuser. However, When I attempt to remove the user from the list using remove-spshelladmin -username I get this error:
"Cannot remove DOMAIN\thisuser from SharePoint_Shell_Access role of the database ourconfigdatabasename. Either the role doesn't exist, or the user is not a member of the role."
I was able to successfully add and remove another user:
add-spshelladmin -username DOMAIN\anotheruser
remove-spshelladmin -username DOMAIN\anotheruser
thisuser has the following roles in the config database:
Any idea why I can't remove thisuser?
Saturday, July 28, 2012 10:36 PM
I haven't seen this problem before, but willing to have a crack at helping.
My gut reaction is that the problem is more in SQL Server than Sharepoint itself. Perhaps the database user has somehow become unlinked from the SQL Server login.
Is anything being logged in the ULS logs that might shed some light on this?
Similarly, anything in the SQL server logs?
Wednesday, August 01, 2012 2:40 PM
Thank you for your reply.
There was nothing in the ULS or SQL server logs that gave a clue.
Due to time constraints we'll not worry about this for now.
- Marked As Answer by dgunnlds Wednesday, August 01, 2012 2:40 PM