Access denied! only site admin can access data source object from user profile db

User profile import started throwing error all of a sudden. Be it either full or incremental, it always ends up with the following error in the crawl log.

This item could not be crawled because the repository did not respond within the specified timeout period. Try to crawl the repository at a later time, or increase the timeout value on the Proxy and Timeout page in search administration. You might also want to crawl this repository during off-peak usage times.

OR

The server is unavailable and could not be accessed. The server is probably disconnected from the network.

Encountered loop when following the manager chain for user with ID

Unable to get domain DNS or forest DNS for domain NT AUTHORITY. ErrorCode=1212

Event ID:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888
Date:  4/18/2010
Time:  11:32:00 PM
User:  N/A
Computer: GOATLAPP35
Description:
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)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have tried running it off-peak hours too but no help!

Analysis of trace logs (key observation):
(Watson Reporting Cancelled) 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) 

Cause:
Ideally, the default content access account should have the right to access and update the user profile database. In our case it was this account which was missing the appropriate permission.

Resolution:
Added the default content access account rights to the user profile database.

Steps to resolve the issue:
Go to Central Administration --> SSP --> User Profiles and properties --> Personalization services permissions
Add the default content access account and provide the "Manage user profiles" permission.

If this post helped you, please visit the sponsors from SharePointAds.com to check the latest offerings