An error has occurred while accessing the SQL Server database or the SharePoint Server Search service

Recently when I was trying to create a new connection in user profile synchronization connections I got the below error which says:

An error has occurred while accessing the SQL Server database or the SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.

An error has occurred while accessing the SQL Server database or the SharePoint Server Search service

An error has occurred while accessing the SQL Server database or the SharePoint Server Search service

The solution what I tried was:

Do an IISRESET in the server. Then it worked correctly.

You can also check the User Profile Synchronization Service should be in the started stage. If required also you can restart the service once.

You may like following SharePoint tutorials:

This SharePoint tutorial, we learned how to solve An error has occurred while accessing the SQL Server database or the SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SPGuides.com

>