SDDL String Contains an invalid SID or a SID that cannot be translated” ERROR During SHAREPOINT 2013 configuration wizard

Error : SDDL String Contains an invalid SID or a SID that cannot be translated” ERROR During SHAREPOINT 2013 configuration wizard 8th Step

Solution :

Browse to
1.  "C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server" folder
2. Right click on Analytics_cf2da844-a5ee-4a2a-898d-e800a936e434 (Analytics_GUID) folder

3.Share the folder as shown below

4. Click ok & Apply 5. Now Run configuration wizard again.

Power Shell script to delete SharePoint Property bag Values.

# Add Powershell Snapin

Add-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue

# Set the variable to removed from property bag

$RemovePropertyBag = "DBConString"

# Get the central admin URL to delete the Property bag value at farm level

$SiteUrl = Get-SPWebApplication -includecentraladministration | where { $_.DisplayName -eq "Sharepoint Central Administration v4" }

# Load Required Assemblies

[System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")

[System.Reflection.Assembly]::Load("Microsoft.Practices.ServiceLocation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35")

[System.Reflection.Assembly]::Load("Microsoft.Practices.SharePoint.Common, Version=2.0.0.0, Culture=neutral, PublicKeyToken=ef4330804b3c4129")

 $site = New-Object Microsoft.SharePoint.SPSite($SiteUrl.URL)

# Get Service locator context and config Manager to set the site context

$serviceLocator = [Microsoft.Practices.SharePoint.Common.ServiceLocation.SharePointServiceLocator]::GetCurrent()

$configManager = $serviceLocator.GetInstance([Microsoft.Practices.SharePoint.Common.Configuration.IConfigManager])

$configManager.SetWeb($site.RootWeb);

 # Get Property Bag

$farmBag = $configManager.GetPropertyBag([Microsoft.Practices.SharePoint.Common.Configuration.ConfigLevel]::CurrentSPFarm)

# set the Value

$configManager.SetInPropertyBag($RemovePropertyBag, "", $farmBag)

write-host "Removing PropertyBag Values $RemovePropertyBag successful"

PowerShell Script to backup WSP from Central Admin's solution gallery

For a specific solution backup

$solution = Get-SPSolution $packageName -ErrorAction SilentlyContinue
# Get the File name from Solution file.
$filename = $solution.SolutionFile.Name
# script to get the location where the script is running -- folder location.
$BaseFolder = (Get-Location -PSProvider FileSystem).ProviderPath
# Save the file to Disk
$solution.SolutionFile.SaveAs("$BackupFolder\$filename")

To backup all the solutions from central admin' solution gallery

$BaseFolder = (Get-Location -PSProvider FileSystem).ProviderPath
$SPSolutions = get-spsolution
foreach($solution in $spsolutions)
{
$filename = $solution.SolutionFile.Name
$solution.SolutionFile.SaveAs("$BackupFolder\$filename")
}