SharePoint 2013 : The SDDL string contains an invalid sid or a sid that cannot be translated

SharePoint 2013 : The SDDL string contains an invalid sid or a sid that cannot be translated

Hi All,

Recently an issue was reported to me where some of my site admins were facing an issue in setting up a SharePoint 2013 stand alone environment. They were facing this error in the step 8 of SharePoint configuration wizard "The SDDL string contains an invalid sid or a sid that cannot be translated".

After spending significant amount of time this issue was finally resolved in this way:

1. Add the account you want to use for search service in WSS_Admin_WPG group. If you are going to use built in administrator account this should be present by default.
2. Then execute this command from sharepoint powershell console:
$SearchService = Get-Credential Domain\UserName

in our scenario of standalone installation the Domain should be the machine name.
3. Then execute this command
New-SPManagedAccount -Credential $SearchService
4. Now Go to "C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server" and find the folder that starts with Analytics with a postfix guid.
5. Right-click --> Properties-->Sharing-->Advanced Sharing
6. Check the "Share this folder' check box and click on Permissions
7. Add the Search Service account created in step 2 and select Full Control. Do the same for WSS_ADMIN_WPG
8. Run the SharePoint Configuration Wizard again. It should now complete successfully.

Rahul Rashu 
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Have you guys changed the Administrator Account Name?

  • When I rerun wizard, search application is already created (with error) and it's not available to checking.

    If I delete search application and rerun wizard, I see the same error about sddl.

  • And I have the problem, that there is no path ""C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server" ".

    I did "normal" install without any dafault value changes.

    But I get the same err.description

  • And I have the problem, that there is no path ""C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server" ".

    I did "normal" install without any dafault value changes.

    But I get the same err.description

  • Thanks, this worked perfectly.  P.S. My Administrator account is unchanged.

  • Had this exact problem and this fixed it.  Thanks for the post.

  • The correct path is C:\program files\windows sharepoint services\15.0\data

Page 1 of 1 (7 items)