none
Configure Synchronization Connections An error has occurred while accessing the SQL Server database RRS feed

  • Question

  • Hi,

    i am getting following error message

    Central Administration --> Synchronization Connections

    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.

    Central Administration -->  Manage Profile Service: User Profile Service Application --> Manage User Properties

    Error
    An unexpected error has occurred.
    Troubleshoot issues with Microsoft SharePoint Foundation.
    Correlation ID: 3bce5a11-f2dc-4788

    Please tell how to fix it.


    iffi

    Thursday, February 9, 2012 7:27 AM

Answers

  • Hi,

    i did IISRESET /NOFORCE  , thanks  to Jie Li - SharePoint.

    http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/c8b67c74-0dec-44c7-b3bf-6c5bab822ea0


    iffi

    • Marked as answer by Seven M Tuesday, February 14, 2012 7:30 AM
    Thursday, February 9, 2012 10:24 AM

All replies

  • Hi iffi.

    Quickest and easiest way that will most likely fix it, reprovision the User Profile Synchronization Service. Simply put. Stop the Synchronization service in Services on server, then restart it again, this will recreate the service and should make it work again.

    (Do not delete and reinstall the UPS Service Application)

    Else, for all things regading t-shooting the UPS, I refer to harbar.net where Spencer Harbar has tons od good info on the UPS.

    Regards


    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blksthl.wordpress.com

    Thursday, February 9, 2012 7:34 AM
  • Hi,

    start and stop but it does not work. still same error.


    iffi

    Thursday, February 9, 2012 7:53 AM
  • Hi,

    i did IISRESET /NOFORCE  , thanks  to Jie Li - SharePoint.

    http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/c8b67c74-0dec-44c7-b3bf-6c5bab822ea0


    iffi

    • Marked as answer by Seven M Tuesday, February 14, 2012 7:30 AM
    Thursday, February 9, 2012 10:24 AM
  • Thanks, iisreset worked for me...the error has gone away.

    Regards,
    Shyam

    Tuesday, October 2, 2012 7:16 AM
  • Just wondering how magical an IISRESET is, many thanks!

    Either you love IT or leave IT

    Sunday, November 4, 2012 9:17 PM
  • Event ID 5555 -> i have change the Timer jobs recycling time AM to PM

    for  User profile page not display  number of count in the page first check services , connection , 

    IISRESET /NOFORCE   /  timer services restart 

       


    Deepesh Yevle MCTS

    Tuesday, February 19, 2013 8:26 AM
  • I am experiencing exactly the same problem as the OP.

    I tried IISRESET /NOFORCE but it made no difference.

    Any other suggestions?


    ~Pandy Legend~

    Wednesday, January 8, 2014 2:47 PM
  • Yes iisreset /noforce work for me as well! Thanks guys!!
    Saturday, January 25, 2014 6:25 PM
  • For me it was simply a case of starting the Forefront Identity Manager Service (Windows service). It had stopped for some reason.

    Brian


    Brian Lalancette | MCTS, MOSS 2007 / SharePoint 2010 | Twitter: @brianlala | Blog: http://spinsiders.com/brianlala

    Saturday, November 15, 2014 1:26 AM
  • Worked ! Thanks.

    Regards,
    Bijay
    SharePoint MVP, India
    Twitter | Facebook | LinkedIn
    EnjoySharePoint.com | OnlySharePoint2013.com

    Monday, December 26, 2016 9:08 AM
  • Yes. starting FIM fixed the issue..

    Thanks,

    Meenakshi

    Tuesday, February 14, 2017 6:01 AM
  • Do the below steps in the server that hosted the user profile sync service

    1. Start the Forefront Identity Manger Service
    2. Restart the Forefront Identity Manager Synchronization Service
    3. IISRESET

    this will solve your issue!!!

    Tuesday, March 28, 2017 4:51 AM
  • Thanks a lot, your answer helped me !
    Wednesday, August 28, 2019 12:44 PM