I have been running the Office 2010 beta for several months now and have been extremely happy with it. Naturally, many applications don't understand how to work with it or detect it properly yet so, as one would expect with a new beta, there are some tweaks required to get things working properly. One such thing is the ability to use Access 2010 to edit a SharePoint list in Datasheet View.

When you first install Office 2010 and then try to edit a SharePoint list in Datasheet View, you'll receive a quaint little message telling you that "a datasheet component compatible with Windows SharePoint Services is not installed". While I'm sure this will be resolved by the time Office 2010 RTMs next month, in the mean time a tweak to correct is necessary.

I was able to find this great post on allowing SharePoint 2007 to properly detect the Office 2010 clients and this has worked on a mix of systems running Windows Vista & Windows 7, both 32 & 64 bit flavors. Thanks to Ivan for writing such a great and useful post!

http://neganov.blogspot.com/2009/11/cannot-edit-sharepoint-2007-list-in.html

A freind of mine wrote this great post on cross-site list views using RSS Feeds and keeping permissions intact. His steps were immensely useful in our environment and I wanted to make sure I shared it.

We are applying the steps outlined in Bryan's post to take the contents of a list view that exists in a departmental site and display the contents of that view on a person's MySite while still maintaining permissions to that list to prevent unauthorized access. Really great post.

http://fsugeiger.blogspot.com/2010/03/cross-site-rss-feed-with-sharepoint.html

After recently converting our SharePoint farm's authentication method from NTLM to Kerberos for Excel Services, PerformancePoint, and SSRS Integration among other things in a distributed environment, I found that People Search stopped working. Search for all other content within our content sources, both inside and outside of SharePoint, continued to work just fine. However, when you perform a search within the People Search, no results would be displayed.

To resolve this, I went into Application Management within the Central Administrator and Extended the web app that MySites were on (which is where the search gathers its People info for during an index) and created a new site that was using NTLM authentication instead of Kerberos. Next, I changed our content source in the SSP's Search Settings so that the People Search utilized the new MySite site instead of the normal one that is using Kerberos - sps3://mysite.domain.com:5556 instead of sps3://mysite.domain.com

Run a full crawl and Voila! - People Search started working properly.

To cut down on the possibility that someone would stumble across the new site and utilize it without Kerberos Authentication, I restricted access to this site via an IIS 7 Authorization Rule so that only the SharePoint service accounts are allowed to access that site. I also created a Server Name Mapping in Search Settings so that anything found in mysite.domain.com:5556 would be automatically rewritten as mysite.domain.com so that users won't know the difference.

I found myself very frustrated earlier this week when I found that SharePoint search was not working. It wasn't returning any errors when you submitted a search. It just wouldn't provide any results.

After a quick glance at the error logs, I found I was getting an Event ID 2436 saying Access Denied:

Details: Access is denied. Verify that either the
Default Content Access Account has access to this repository, or add
a crawl rule to crawl this repository. If the repository being crawled is a
SharePoint repository, verify that the account you are using has
"Full Read" permissions on the SharePoint Web Application
being crawled. (0x80041205)

Naturally, I immediately checked my Web Application Policy to confirm that my Search account had Read Access in case someone inadvertantly removed it. However, it was still there.

After about half the morning of removing and re-adding permissions and resetting passwords and re-creating the index, I finally found several posts pointing at the .NET 3.5 SP1 update causing this problem. Sure enough, the update had been installed over the weekend.

Thankfully, this one was an easy fix that could be done on the fly. Open RegEdit and go to HKLP\System\CurrentControlSet\Control\Lsa and create a new DWORD value named DisableLoopbackCheck. Then, set the value to 1. Lastly, restart the WSS Search service and then run the following from a command line to initiate a full crawl:

stsadm -o spsearch -action fullcrawlstart

Within a couple minutes, search was back online and users were happy.

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.