Mike Laurencelle

I'm a SharePoint & Server Systems Administrator for Sears Home Improvement Products, headquartered in sunny Longwood, Florida. My primary functions revolve around SharePoint and Virtualization technologies.

I've been in the IT industry now for about 18 years. For me, IT is more than a job to make a living, more than a career to call my own. It's my passion. I am a self proclaimed geek and have interest in all things technology. I can't imagine being in any other field - I absolutely love what I do.

Event ID 7888 in MOSS


Posted on : 8:29 PM | By : Mike Laurencelle

I was recently having an issue after setting up MOSS where I kept seeing Event ID 7888 in the event logs.

Event ID 7888
Event Type: ErrorEvent Source: Office SharePoint ServerEvent Category: Office Server General Event ID: 7888

A runtime exception was detected. Details follow.
Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Techinal Details:
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site)
at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.GetDataSource()
at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)

This turned out to be that the search account did not have all of the necessary permissions. If you are following best practices by using multiple accounts for different jobs within SharePoint, you may need to verify eactly which account is causing this error.

  1. Go to Central Administrator >> Operations tab >> Services on Server >> Office SharePoint Server Search.
  2. Click on "Configure Office SharePoint Server Search Service Settings.
  3. Locate the account listed under "Configure Profile Account" flr the "Farm Search Service Account"

Now you know which account to give the privilages to.

  1. Go to Central Administrator >> Shared Services >> Personalization Services Permissions
  2. On the "Manage Permissions: Shared Services Rights" page, make sure the account you found is listed with "Manage user profiles" rights. If it is not listed with this permission, add it.

After updating this permission, the Event ID 7888 problem should go away.