Article – Fix it – SharePoint 2013 User Profile Synchronization Service cannot be started with SQL Server 2014
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 – http://www.sharepoint24x7.com/2011/01/09/configuring-user-profile-services-in-sharepoint-server-2010/
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.
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
I did all these but no luck
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…!!!
Based on my investigation, I believe that SQL Server 2014 is the culprit and applying June 2015 CU resolved the issue.
Yesterday we had our July monthly user group gathering for Sri Lanka SharePoint User Group. We had 02 sessions – Business Continuity and Office 365 API.
Dinusha delivered a session on Office 365 API.
I delivered a session on implementing a business continuity for SharePoint and I covered topics such as monitoring SharePoint using Health Analyzer, Diagnosing logging, Usage and health data collection, implementing high availability using distributing servers and services using SharePoint WFEs, Application services servers, network load balancing, database mirroring, backup SharePoint and SQL Server databases and scheduling using Windows Task Scheduler.
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:
- Change the recovery model for the Database from Full to Simple
- 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.
ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE ('SharePoint_Config_Log')
Organized by Totalamber, in association with Nintex and Microsoft, Sri Lanka, the Launch of ‘Nintex’ in Sri Lanka took place at the Galle Face Hotel, Colombo on 4th June, 2015.
The keynote presentation was given by Mr. Kok Koon Gan, Technical Evangelist for Nintex, with Mr. Imran Vilcassim, Country Manager of Microsoft Sri Lanka, as a guest speaker. Invitees for the event included CIOs, IT Managers and decision makers from leading blue chip companies, financial organizations and other recognized companies in the island.
I delivered a session – “Bringing Experiences together”, highlighting the availability of new developments and capabilities including Cloud-Inspired Experiences, in the upcoming release of SharePoint – SharePoint 2016 as well as Office 365. It is expected for Nintex to benefit extensively by leveraging on the new cloud and on premise features.
Yesterday we had our March monthly user group gathering for Sri Lanka SharePoint User Group. We had 02 sessions lined up – Search and Branding.
Malin delivered a session around Branding and Design Manager capabilities. I delivered a session around SharePoint Search which covered configuring multiple content sources, result sources, query rules, etc…
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:
Learn how to navigate through SharePoint ULS logs using PowerShell.
I was very fortunate to take part in the 4th episode of Southeast Asia SharePoint Conference held on 25th and 26th November, 2014 in Singapore.
I was fortunate to deliver the one and only session on SharePoint Search and there was a very good no of attendees even if it was the very first session on the 2nd day. I demonstrated lot of new features of SharePoint 2013 Search including Result Sources, Query Rules, KQL, etc…
It was my pleasure being part of this great event and I am happy a lot since there were 02 other speakers from Sri Lanka.
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.
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.