Sharepoint site collection administrator lost full permission issue

Problem

Today I faced a strange problem in SharePoint 2010.

It happened all of a sudden that permission has been lost for all the users on specific site collection, however i tried to login by the farm admin and site collection admin but i don’t have administrator permissions so i can’t add users or add user. Just i see the site but i can’t do any operation this problem just happened on one site collection but other site collection working well

Symptoms

Resolution

Run the below command to know the status of your web application content database

stsadm -o getsitelock -url [site]

Reference: http://technet.microsoft.com/en-us/library/cc262915.aspx

If the command returns as “Read-only” you will need to change to “None” to unlock database.

stsadm -o setsitelock -url http://server_name -lock none

Reference: http://technet.microsoft.com/en-us/library/cc262811.aspx

Advertisements

About Joseph Velliah
As a SharePoint Developer my professional interests tend to be technical and SharePoint focused. I run a blog at "SP RIDER" where you can expect to read HOW TOs and scenarios that I run into during my day to day job. I hope my posts will give back a little to the community that is helped me.

7 Responses to Sharepoint site collection administrator lost full permission issue

  1. Gurudatta says:

    Thank you very much.
    I dont know how my site got locked because of this I am unable to deploy solution.
    After following your steps site got unlocked and able to deploy solution.

    Thank you once again.

  2. Mohan Kumar says:

    You rock dude. I ran into this issue on our production portal after applying patches over the weekend. Many hours of stress later I stumbled on this post, and it saved the day. Many thanks!

  3. Marc Johnson says:

    Happy to report this fixed our issue as well… Can’t thank you enough!!

  4. haobui2910 says:

    thank you so muchhhhhhhh. this post saved the day and worked like a charm!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: