Monday 17 June 2013

The SDDL string contains an invalid sid or a sid that cannot be translated in Sharepoint 2013

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 o 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.

Thanks,
Rahul Rashu