SharePoint Installation Problems

SharePoint Installation Problems

When I installed SharePoint 2013 Foundation on Windows 2012 R2 I found a few problems. The Wizard for SharePoint does not help with everything and to install it,  I needed to do a lot of manual work. So below I collected all of the problems with the solution that I found during installation.


Problem:  Microsoft SharePoint 2013 Preparation Tool taking too long. You wait hours, days when this tool will configure for you Application Server Role  or Web Server IIS Role

Solution: Close the Server Manager Windows


Problem: The Products Preparation Tool in SharePoint Server 2013 may not progress past “Configuring Application Server Role, Web Server (IIS) Role”

Solution: Use PowerShell script:

(original article: https://support.microsoft.com/en-gb/kb/2765260)


Problem: SharePoint Products Configuration Wizard: Configuration Failed to create the configuration database

Solution: Change settings in SQL Server Instance:

  1. Open Microsoft SQL Server Management Studio
  2. Login with sysadmin user
  3. Right click on instance name and select properties -> Advanced
  4. Change Max Degree of Parallelism to 1
  5. Restart the SQL Service

(original article: http://sps2013.blogspot.co.uk/2013/01/this-sqlserver-instance-does-not-have.html)


Problem: SharePoint Products Configuration Wizard: Configuration Failed to secure the SharePoint resources

Solution: Change Folder Owner for C:\Windows\Task to local Administrators group


Problem: The SDDL string contains an invalid sid or sid that cannot be translated

Solution: It happened when you use standalone installation

  1. Create a search service user and add to the WSS_ADMIN_WPG group.
  2. Type in SharePoint powershell console:
  3. $SearchService = Get-Credential Domain\UserName
  4. New-SPManagedAccount -Credential $SearchService
  5. 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.
  6. Right-click –> Properties–>Sharing–>Advanced Sharing
  7. Check the “Share this folder’ check box and click on Permissions
  8. Add the Search Service account created in step 2 and select Full Control. Do the same for WSS_ADMIN_WPG
  9. Run the SharePoint Configuration Wizard again. It should now complete successfully.

(original article: https://social.technet.microsoft.com/wiki/contents/articles/17933.sharepoint-2013-the-sddl-string-contains-an-invalid-sid-or-a-sid-that-cannot-be-translated.aspx)


Problem: SharePoint 2013 Cumulative Update takes too long 

Solution: Use PowerShell script:

(original articles and more information: https://blogs.msdn.microsoft.com/russmax/2013/04/01/why-sharepoint-2013-cumulative-update-takes-5-hours-to-install/)