Environment: SharePoint 2013 Foundation
Requirement: Uninstall existing SharePoint 2013 Enterprise and Install SharePoint 2013 Foundation
Issue: After uninstalling the existing SP2013 and successful 2013 Foundation installation, the installation failed during running SharePoint products configuration wizard. It failed at the step 8 of 9 throwing following error message.
Configuration failed.
One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure.
Failed to upgrade SharePoint Products
An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: Failed to upgrade SharePoint Products
Resolution:
As it turns out to be insufficient SQL Server database permissions. Also noticed that the SharePoint timer job was running with Network Credentials account.
Following are the steps involved to resolve this issue.
In Central Administration Web site, click Security > Configure Service Accounts.
In Credential Management section, select the Web application pool for your Web application.
In the Select an account for this component section, select the service account that you want to associate with this Web application pool, or click Register new managed account to associate a new service account with this application pool.
Click OK
Update the SharePoint timer job service to run on the same service account.
