Sharepoint Read-Only after restore and (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

After restoring your Sharepoint Collection Site you get access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

You notice that owners, Administrator, an members don’t have write access and when trying to add a user, or any other write command to the site you get:

stsadm -o adduser -url http://wssServer -userlogin matOS\e1m -useremail e1m@theemail.com -role "Full Control" -siteadmin -username "Eddie"

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

I personally started getting this error when the site was in a locked state, drove me crazy since I thought it was related with permissions or inheritance. Plus my restored at the moment came from a production Domain, and I was restoring in a Testing environment with a testing Domain with different SID

Another reason is because your site it’s over the Quota limit, or because the site was locked when you took the backup of the site.

Not even the Owners, Members, or even Application Administrator will have write access to the site.

This command will remove the lock of you site collection.

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

Using the Central Administration you can click under Application Management
Click on "Site Collection Quotas and Locks", select your site collection and set it to “Not locked”.

More info at http://technet.microsoft.com/en-us/library/cc287893.aspx

Backup/Move/Migrate Windows Sharepoint Services 3 Sites

We know there are multiples way to backup an WSS ( Windows Sharepoint Services ) stsadm/Central Administration/BE Agent/System Center DPM, etc.

Out of all of them I prefer to use stsadm. Specially because it allows you me to backup and specific site collection and restore it to any other server in another AD ( Adtive Directory ) or the same AD.

It won't matter if it's a different Hardward or topology.

Here are the steps

Source server you just run

stsadm.exe -o backup -url http://wss-matostech -filename c:\site1.bak -overwrite
stsadm.exe -o backup -url http://wss-matostech/sites/main -filename c:\site2.bak -overwrite

Targe server

You must create two new sites http://new-server/s1-s2, or http://new-server/sites/s1-s2. Not doing this will override any new information of thi server.

stsadm.exe -o restore -url http://new-server/s1 -filename c:\site1.bak -overwrite
stsadm.exe -o restore -url http://new-server/s1 -filename c:\site2.bak -overwrite

Connectin to [ Windows Internal Database / SQL Server 2005 Embedded Edition ]

Windows SharePoint Services (WSS) and Windows Server Update Services (WSUS) use this database. If you need to connect to these databases for any reason you should:

1) Download “SQL Server Management Studio Express” and Install it.
2) When it asks you to connect type \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query in the server name address and Windows Authentication.

You should now be able to browse any of databases