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.
I have been trying the new SharePoint Server 2016 bits for few months through the TAP programs and now time has come to talk about in public.
Microsoft released SharePoint Server 2016 preview build 16.0.4316.1217 on 10th August for TAP participants and now the same build has been released to public.
It’s pointless recreating the same blog and visit Bill Baer’s post about to get more information on the SharePoint Server 2016 IT Preview.
Announcing availability of SharePoint Server 2016 IT Preview and cloud hybrid search - https://blogs.office.com/2015/08/24/announcing-availability-of-sharepoint-server-2016-it-preview-and-cloud-hybrid-search/
SharePoint Server 2016 IT Preview Reviewer Guide - http://www.microsoft.com/en-us/download/details.aspx?id=48713
Download SharePoint Server 2016 IT Preview - http://www.microsoft.com/en-us/download/details.aspx?id=48712
This preview meant and focuses on infrastructure new features and enhancements and I believe that’s why they call is as IT Preview.
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.
Industrial training for year 2015/ 2016 is just about to begin. University of Moratuwa organized a series of sessions (“Pitch Your Company”) for various registered companies to present their industrial training offerings to all the students.
We presented today our industrial training offerings and opportunities available at Totalamber and we were the only to showcase capabilities of SharePoint and Microsoft Dynamics platforms and who offered opportunities to them in SharePoint and Dynamics as a career path.
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.