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?
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?