Unable to remove a user from shell admin list

Question

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:

Remove-SPShellAdmin :
 "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:

• db_owner
• db_securityadmin
• SharePoint_Shell_Access

Any idea why I can't remove thisuser?

---

David

Answer 1

Hi David

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?

Steve

Answer 2

spv uk:

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.

---

David