Joy's Blog Learning never stops…!!!


Article – Tips and Tricks – Selecting Services to run in the farm in SharePoint 2016 IT Preview

Posted by Joy

I assume by now most of you have installed and tried SharePoint 2016 IT Preview.

Except the change in the Specify Server Role page in the SharePoint Products Configuration Wizard asking us to specify the role of the server (Min-role), another change we can see in the installation and configuration of SharePoint 2016 IT Preview is, we can specify what services we want to run in the farm using Initial Farm Configuration Wizard.

As you can see below, we get a new section in Initial Farm Configuration Wizard, right below Service Applications selection, to choose what services we need to run in the farm.

Services in the farm

This reduces one of the configuration steps which we need to after running Initial Farm Configuration Wizard in the previous versions of SharePoint.


Article – Fix it – SharePoint 2013 User Profile Synchronization Service cannot be started with SQL Server 2014

Posted by Joy

I wrote an article on configuring User Profile Service for SharePoint 2010 and I have been using/ following the same steps for so many implementations up until last week.

For those who have not read it before –

However, I installed a new environment for one of our client last week and tried to start the User Profile Synchronization Service using Manage services on server page in Central Administration web site and it did not work.


When I click Start link to start the User Profile Synchronization Service, it stays in “Starting” state for some time (actually little longer) and then goes back to “Stopped” state. Sad smile Sad smile

Troubleshooting steps:

I executed all the following troubleshooting tasks and made sure that I tried all the possible solutions based on my experience and others experience:

  • Adding Farm service account in to the Administrators group
  • Deleting User Profile Services service application and recreating it
  • Verify the password of Farm service account
  • Clearing SharePoint Configuration Cache
  • Changing the Log On As account for Forefront Identity Manager Service and Forefront Identity Manager Synchronization Service
  • Etc…

I did all these but no luck Sad smile Sad smile Sad smile

Hhhmmmmm Thinking smile Thinking smile Thinking smile

I started investigating further and noticed following:

  • I managed to successfully start/ configure User Profile Synchronization Service on 03 VMs with Windows Server 2012 R2, SharePoint Server 2013 with Service Pack 1 and SQL Server 2012 R2
  • I failed to start/ configure User Profile Synchronization Service in 03 VMs with Windows Server 2012 R2, SharePoint Server 2013 with Service Pack 1 and SQL Server 2014

I downloaded and applied June 2015 Cumulative Update for SharePoint Server 2013.

Woooohhhhooooo…!!!! It worked…!!! Smile Smile Smile


Based on my investigation, I believe that SQL Server 2014 is the culprit and applying June 2015 CU resolved the issue.


Article – Tips and Tricks – reducing the SharePoint Config Log file

Posted by Joy

Today we came across with a situation where we keep getting a runtime error when we try to perform our normal day-today operations in our SharePoint 2013 based solution. It started throwing a runtime error with a error code - HRESULT: 0x80131904 and it failed to save data into the SharePoint database.

The reason was the SharePoint Configuration database LOG file has grown to 91 GB and there was not enough free space in the physical disk. Because of this, SharePoint was unable to commit database changes and there was a huge performance impact. The solution we found was:

  1. Change the recovery model for the Database from Full to Simple
  2. Shrink the database

I executed the following SQL command and it brought the database log file from 91GB to 1 MB which solved my issues.

USE [master]


USE [SharePoint_Config]

DBCC SHRINKFILE ('SharePoint_Config_Log')


Article – Tiles (Metro UI) Navigation web part in SharePoint 2013

Posted by Joy

Did you know that we can implement Metro UI in SharePoint 2013? It can be implemented very easily with out-of-the-box features in SharePoint 2013.

Learn how to implement Tiles navigation in SharePoint 2013:


Article – Tips and Tricks – navigating through SharePoint ULS logs using PowerShell

Posted by Joy

Learn how to navigate through SharePoint ULS logs using PowerShell.


Article – Customizing SharePoint 2013 Search Results with Query Rules – User Intent

Posted by Joy

User Intent is a new way of customizing SharePoint 2013 Search experience.

Learn how to customize SharePoint 2013 search results with Query Rules – User Intent.


Article – Customizing SharePoint 2013 Results using Result Sources

Posted by Joy

Result Sources is a new concept in SharePoint 2013 search which allows us to customize search results.

Learn how to customize SharePoint search results using Result Sources.


Article – Tips and Tricks – enabling Geolocation field in SharePoint 2013

Posted by Joy

Geolocation field is new to SharePoint 2013 and it allows us to store latitude and longitude values giving SharePoint awareness of location information.

Learn how to enable geolocation field in SharePoint 2013.


Article – What’s new and improved in Visio 2013 Workflow designer

Posted by Joy

Visio 2013 has been improved a lot with regard to workflow designing for SharePoint.

Learn what’s new and improved in Visio 2013 workflow designer for designing workflows for SharePoint.


Article – Enabling Continuous Crawling in SharePoint 2013 Search

Posted by Joy

Continuous Crawling is a brand-new feature in SharePoint 2013 Search. This enables us to keep our Search Index up-to-date as much as.

Learn how to enable continuous crawling in SharePoint 2013 search.