SharePoint Configuration Failure

Question

SharePoint Configuration failing at stage 5. Please advise best steps to use to complete configuration.

05/03/2023 16:17:29 17 INF Entering function TaskBase.OnTaskStop

05/03/2023 16:17:29 17 INF Creating the OnTaskStop event for task services

05/03/2023 16:17:29 17 ERR Task services has failed

05/03/2023 16:17:29 17 INF friendlyMessage for task services is An exception of type System.Reflection.TargetInvocationException was thrown. Additional exception information: Exception has been thrown by the target of an invocation.

05/03/2023 16:17:29 17 INF debugMessage for task services is An exception of type System.Reflection.TargetInvocationException was thrown. Additional exception information: Exception has been thrown by the target of an invocation.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated.

at System.Security.Principal.SecurityIdentifier.Translate(IdentityReferenceCollection sourceSids, Type targetType, Boolean forceSuccess)

at System.Security.Principal.SecurityIdentifier.Translate(Type targetType)

at Microsoft.SharePoint.Utilities.SPUserUtility.SidToAccountName(SecurityIdentifier sid)

at Microsoft.SharePoint.Utilities.SPUserUtility.IsLocalAccount(SecurityIdentifier sid)

at Microsoft.SharePoint.Utilities.SPUserUtility.WarnIfLocalAccountOnFarm(SecurityIdentifier sid, String accountUser)

at Microsoft.SharePoint.Administration.SPProcessIdentity.set_ManagedAccount(SPManagedAccount value)

at Microsoft.Office.Project.Server.Administration.ProjectServiceBase..ctor(String name, SPFarm farm)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

at Microsoft.SharePoint.PostSetupConfiguration.ReflectionHelper.InvokeConstructor(String assemblyQualifiedName, Type[] constructorSignature, Object[] constructorParameters)

at Microsoft.SharePoint.PostSetupConfiguration.TaskCommon.ReflectionHelperInvokeConstructor(String assemblyQualifiedName, Type[] constructorSignature, Object[] constructorParameters, TaskBase task)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InvokeServiceConstructor(String serviceRegistryKeyName, String solutionIdRegistryName, String serviceNameRegistryName, Type[] constructorSignature, Object[] constructorParameters)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInConfigDB(Boolean provisionTheServiceToo, String serviceRegistryKeyName)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServices(Boolean provisionTheServicesToo)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.Run()

at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

05/03/2023 16:17:29 17 INF Entering function TaskBase.FireTaskStateChanged

05/03/2023 16:17:29 17 INF Firing the OnTaskStateChanged event for task services

05/03/2023 16:17:29 17 INF Entering function TaskDriver.TaskStateEventHandler

05/03/2023 16:17:29 17 INF Entering function StringResourceManager.GetResourceString

05/03/2023 16:17:29 17 INF Resource id to be retrieved is ServicesTaskDisplayName for language English (United States)

05/03/2023 16:17:29 17 INF Resource retrieved id ServicesTaskDisplayName is service registration

05/03/2023 16:17:29 17 INF Leaving function StringResourceManager.GetResourceString

05/03/2023 16:17:29 17 INF Received an TaskStateEventHandler event. task:services TaskBase.State:stopped

05/03/2023 16:17:29 17 INF Entering function TasksQueue.IncrementTaskFailed

05/03/2023 16:17:29 17 INF Incremented the number of tasks failed to 1

05/03/2023 16:17:29 17 INF Leaving function TasksQueue.IncrementTaskFailed

05/03/2023 16:17:29 17 INF Task services has stopped and failed. Total failed is now 1

05/03/2023 16:17:29 17 INF Leaving function TaskDriver.TaskStateEventHandler

05/03/2023 16:17:29 17 INF Entering function PsconfigBaseForm.TaskStateEventHandler

05/03/2023 16:17:29 17 INF Invoking the UI thread with the task state chagne event

05/03/2023 16:17:29 1 INF Entering function ConfigurationProgressForm.InvokeTaskStateEventHandler

05/03/2023 16:17:29 1 INF Received an TaskStateEventHandler event. task:services TaskBase.State:stopped TaskBase.TaskResultservices

05/03/2023 16:17:29 1 INF Acquiring the reader lock to retrieve the state

05/03/2023 16:17:29 1 INF Releasing the reader lock to retrieve the state

05/03/2023 16:17:29 1 INF Acquiring the reader lock to retrieve the state

05/03/2023 16:17:29 1 INF Releasing the reader lock to retrieve the state

05/03/2023 16:17:29 1 ERR Task services has stopped and failed. Total failed is now 1

05/03/2023 16:17:29 1 INF Entering function StringResourceManager.GetResourceString

05/03/2023 16:17:29 1 INF Resource id to be retrieved is ServicesTaskFailConfigDisplayLabel for language English (United States)

05/03/2023 16:17:29 1 INF Resource retrieved id ServicesTaskFailConfigDisplayLabel is Failed to register SharePoint services.

05/03/2023 16:17:29 1 INF Leaving function StringResourceManager.GetResourceString

05/03/2023 16:17:29 1 INF Updating the task label below the progress bar Failed to register SharePoint services.

05/03/2023 16:17:29 1 INF Entering function FormParameterCollection.Add

05/03/2023 16:17:29 1 INF Leaving function FormParameterCollection.Add

05/03/2023 16:17:29 1 INF Entering function FormParameterCollection.Get

05/03/2023 16:17:29 1 INF Leaving function FormParameterCollection.Get

05/03/2023 16:17:29 1 INF Last message from task services is An exception of type System.Reflection.TargetInvocationException was thrown. Additional exception information: Exception has been thrown by the target of an invocation.

05/03/2023 16:17:29 1 INF Updating the task additional notification information below the progress bar An exception of type System.Reflection.TargetInvocationException was thrown. Additional exception information: Exception has been thrown by the target of an invocation.

05/03/2023 16:17:29 1 INF Leaving function ConfigurationProgressForm.InvokeTaskStateEventHandler

05/03/2023 16:17:29 17 INF Sleeping an extra 1 ms so things don't go too fast for the user for this task

05/03/2023 16:17:29 17 INF Leaving function PsconfigBaseForm.TaskStateEventHandler

05/03/2023 16:17:29 17 INF Leaving function TaskBase.FireTaskStateChanged

05/03/2023 16:17:29 17 INF Leaving function TaskBase.OnTaskStop

05/03/2023 16:17:29 17 INF Leaving function TaskThread.ExecuteTask

05/03/2023 16:17:29 18 INF Entering function StringResourceManager.GetResourceString

05/03/2023 16:17:29 18 INF Resource id to be retrieved is ServicesTaskDisplayName for language English (United States)

05/03/2023 16:17:29 18 INF Resource retrieved id ServicesTaskDisplayName is service registration

05/03/2023 16:17:29 18 INF Leaving function StringResourceManager.GetResourceString

05/03/2023 16:17:29 18 ERR Task service registration failed, so stopping execution of the engine

05/03/2023 16:17:29 18 INF Entering function StringResourceManager.GetResourceString

05/03/2023 16:17:29 18 INF Resource id to be retrieved is ServicesTaskFailConfigDisplayLabel for language English (United States)

05/03/2023 16:17:29 18 INF Resource retrieved id ServicesTaskFailConfigDisplayLabel is Failed to register SharePoint services.

05/03/2023 16:17:29 18 INF Leaving function StringResourceManager.GetResourceString

05/03/2023 16:17:29 18 ERR Failed to register SharePoint services.

An exception of type System.Reflection.TargetInvocationException was thrown. Additional exception information: Exception has been thrown by the target of an invocation.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated.

at System.Security.Principal.SecurityIdentifier.Translate(IdentityReferenceCollection sourceSids, Type targetType, Boolean forceSuccess)

at System.Security.Principal.SecurityIdentifier.Translate(Type targetType)

at Microsoft.SharePoint.Utilities.SPUserUtility.SidToAccountName(SecurityIdentifier sid)

at Microsoft.SharePoint.Utilities.SPUserUtility.IsLocalAccount(SecurityIdentifier sid)

at Microsoft.SharePoint.Utilities.SPUserUtility.WarnIfLocalAccountOnFarm(SecurityIdentifier sid, String accountUser)

at Microsoft.SharePoint.Administration.SPProcessIdentity.set_ManagedAccount(SPManagedAccount value)

at Microsoft.Office.Project.Server.Administration.ProjectServiceBase..ctor(String name, SPFarm farm)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

at Microsoft.SharePoint.PostSetupConfiguration.ReflectionHelper.InvokeConstructor(String assemblyQualifiedName, Type[] constructorSignature, Object[] constructorParameters)

at Microsoft.SharePoint.PostSetupConfiguration.TaskCommon.ReflectionHelperInvokeConstructor(String assemblyQualifiedName, Type[] constructorSignature, Object[] constructorParameters, TaskBase task)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InvokeServiceConstructor(String serviceRegistryKeyName, String solutionIdRegistryName, String serviceNameRegistryName, Type[] constructorSignature, Object[] constructorParameters)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInConfigDB(Boolean provisionTheServiceToo, String serviceRegistryKeyName)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServices(Boolean provisionTheServicesToo)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.Run()

at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

05/03/2023 16:17:29 18 INF Entering function get CommandCollection.this[string key]

05/03/2023 16:17:29 18 INF Entering function CommandCollectionBase.Get

05/03/2023 16:17:29 18 INF Found value in collection for key initialize

05/03/2023 16:17:29 18 INF Leaving function CommandCollectionBase.Get

05/03/2023 16:17:29 18 INF Found command initialize in collection

05/03/2023 16:17:29 18 INF Leaving function get CommandCollection.this[string key]

05/03/2023 16:17:29 18 INF Entering function Command.this[string key]

05/03/2023 16:17:29 18 INF Entering function CommandCollectionBase.Get

05/03/2023 16:17:29 18 INF Found value in collection for key B2B_UPGRADE

05/03/2023 16:17:29 18 INF Leaving function CommandCollectionBase.Get

05/03/2023 16:17:29 18 INF Found parameter B2B_UPGRADE in collection

05/03/2023 16:17:29 18 INF Leaving function Command.this[string key]

05/03/2023 16:17:29 18 INF Entering function TaskDriver.NotifyTaskSummary

05/03/2023 16:17:29 18 INF Entering function StringResourceManager.GetResourceString

05/03/2023 16:17:29 18 INF Resource id to be retrieved is TotalTasksRan for language English (United States)

05/03/2023 16:17:29 18 INF Resource retrieved id TotalTasksRan is Total number of configuration settings run: {0}

Answer 1

Hello there,

This is a common issue when uninstall and reinstall SharePoint on the same machine, some files in the MachineKeys folder give access denied error even though you had local administrative privileges.

Please set the MachineKeys folder to have the correct default Permissions referred to https://learn.microsoft.com/en-GB/troubleshoot/windows-server/windows-security/default-permissions-machinekeys-folders

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Answer 2

Hi Tevon,

Did you post all relevant logs?

Could you please provide the error message displayed on the PC wizard interface?

According to my research, I can't reproduce your situation, so here are some methods for you to try:

For "System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated"

You can try this:

• Make sure SQL Server is running on a service account that is granted with local administrator access rights! (Not running on accounts such as local service, network service!)

If so, update the Log On account of SQL Server Service in your database server.

• Check TCP/IP and Named Pipes protocols are enabled in SQL Server. 
• Check your Firewall. Turn it off for the time being. Check your event logs for any antivirus related blocks.  
• Make sure your setup account (or the account you are currently logged in and running the SharePoint Products Configuration Wizard) is granted with: dbcreator, securityadmin and sysadmin access rights in SQL Server.
• Check the application pool identity for the “SharePoint central administration” site! It should be your Farm account and not  “network service”
• Do not use your service account username has with more than 20 characters (SharePoint uses the pre-windows 2000 username)
• If all fails, Run PSConfig command line, and then try running the Products configuration Wizard GUI again!
  psconfig -cmd configdb <-create/connect> -server <db-servername> -database <database name> -user <service-account-username> -password <password> -admincontentdatabase <content database name>
• Delete the config database in Database Server. Delete the Central admin site and App Pool in IIS. and try running the wizard again.

Rerun the SharePoint Configuration wizard after fixing the above workarounds.

For more information, please refer to:

https://www.sharepointdiary.com/2015/02/configuration-failed-failed-to-create-configuration-database.html

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Also, I found some similar posts, hope it can give you some inspiration.

https://social.technet.microsoft.com/Forums/en-US/94a8bb64-e0ea-493f-8e29-01347b1fc6c7/psconfig-fails-quotfailed-to-upgrade-sharepoint-productsquot?forum=smallbusinessserver

https://social.technet.microsoft.com/Forums/windows/en-US/9c832f55-7eda-4173-bd2a-b59aa03fbeb1/failed-to-run-sharepoint-products-configuration-wizard?forum=sharepointadminprevious

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.