Sharepoint 2010 Access Denied Error for all users

Hi,
This problem cost me 2,5 days to figure it out.

I needed to change the service password of the server, after I did that (along with changing managed account pass, iis app pool passes and all services credentials) I could not login to one of my Web App !

I ve got "Access Denied" error even for admins..

Solution was to delete the Web App and creating a new one and associating the old content db with this new web app.

Steps:

- Delete Web App via Central Admin (Click Delete - On upcoming window choose delete IIS but NOT delete Content DB)
- Created new web App with same name but with different content_db name. (we are just going to replace it anyway)
- Make the new web App content db offline:  CA - Application Management - Manage Content Databases-Select the db, Make the Database Status- Offline
- Run the following stsadm command to bind the old content db:
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
Thats all



Other solutions I ve tried:

- Check if db is read only: (CA - Application Management - Manage Content Databases-Select the db Check the status) or Run this SQL:
SELECT name, is_read_only

FROM sys.databases
- Check if Site Collection is read only  (locked) CA - Application Management - Configure quatas and locks
- Check if the IIS folders permissions are OK: Go to IIS folder of the WEb App, check the security tab and check if your user is in the admin users. (WPG ADMIN, Administrators, etc.)
- Check the IIS Application Pool user-passwords are OK
- Check the all the Services running have the right credentials (Run services.msc checked all the services using this account)
- Check if the user in Web App User Policy (Object Cache): CA - Application Management - Select web app - Select User Policy on Top - Check the reader and superuser accounts (there are plenty of links in google..)
- Check if another page in the Web App is working: Just check http://yoursite/_layouts/settings.aspx. If it is working fine for all users, then you ve got something wrong in your homepage. Probably a webpart or a custom control does not have sufficent permission.

Sharepoint 2010 - No content databases in the web application were available to store your site collection

Hi,
One of the weird behaviours of Sharepoint is that if you remove a site collection and restore it it would give the error "The operation that you are attempting to perform cannot be completed successfully. No content databases in the web application were available to store your site collection. The existing content databases may have reached the maximum number of site collections, or be set to read-only, or be offline, or may already contain a copy of this site collection. Create another content database for the Web application and then try the operation again."

The reason is that the deleted solution is not deleted, it is still in some sort of a Recycle Bin of SP, so if you d like to restore the SC, SP prompt you this error.

For example,
If you delete the SC from the Central Admin, you ll see the deleted site is still in somewhere.

You can see the deleted site with the command (PowerShell)

get-spdeletedsite

In order to delete this site properly, you can use one of the following commands:

Remove-SPSite –Identity http://sharepoint.com
get-spdeletedsite -webapplication http://sharepoint | Remove-SPDeletedSite
remove-spdeletedsite a56372bd-c6cc-4389-a8cb-089e0cddf7e3 -confirm:$false

But, keep in mind that the Gradual Delete Job would not delete the site right away, even you query the deleted site list with  "get-spdeletedsite" command, you ll see nothing, it doesn t mean that they are removed.

I think the Gradual Delete Job works once in a day or sth like that, so you should start the job manually.

Since I have done this job at the end of the day, in the morning everything was just fine.

I ll share if I can find how to trigger the job manually, I think it is in Central Admin - Monitoring..

Cheers


Source:

http://sharepoint.stackexchange.com/questions/31048/restore-spsite-reports-no-content-databases-are-available-for-this-operation
http://reality-tech.com/2012/04/04/gradual-site-collection-deletion/

Sharepoint 2010 Restore a site collection backup

Hı,

If you d like to restore a site collection you should open the PowerShell as admin and type the following command:


Restore-SPSite -Identity "http://yoururl" -Path "C:\SiteCollectionBackups\backup.bak" -Force


Source:
http://sharepointciyiz.biz/post/2011/07/08/SharePoint-2010-Site-Collection-Backup-and-Restore.aspx

Sharepoint 2010 Uninstall a feature

Sometimes if you restore a site collection, you might need to deactivate and uninstall a infopath form and reupload it.

To do that, first go to your site - Site Settings - Site Collection Administration (Go to "Go to top level site settings" if necessary) - Site collection features - Deactivate the feature.

Get the GUID on the link, you ll need it to uninstall

Then,
Uninstall the corresponding feature using stsadm

stsadm.exe -o uninstallfeature -id 9fd01052-5564-8ed4-e2b7-a563e9898f08 -force

Sometimes, copy-pasting above code does not work, simply write it yourself.


Bye !