Datasheet View Does Not Work in SharePoint 2010

This is a known and personally experienced issue (Tech Preview and Beta Builds as well) with Datasheet View not working in SharePoint if you have Office 2010×64 clients installed on your workstation.

Again this is one of the FAQ on the MSDN Forums and today I saw the solution posted on the thread, so comes this post for my reference and in case you experience this, then you know what is the solution to the issue.

Read the rest of this entry »

Trial Period Expired in Search Server Express 2010

One of the FAQ on SharePoint 2010 forums is for an alert generated by the Health Analyzer in the Search Server Express 2010 installation instance.

Read the rest of this entry »

SharePoint Error – Unable to update the information in the Microsoft Office document

Today I received a call from one of my clients requesting help with a SharePoint error.

The client had uploaded an Excel spreadsheet and when trying to update the properties of the document, SharePoint displayed this error “Unable to update the information in the Microsoft Office document”.

Read the rest of this entry »

Outgoing email issue resolved

Situation

  • New SharePoint deployment.
  • Outsourced IT operations.

Problem

SharePoint alerts not working for users.

Cause

Outgoing email address is configured to support@serviceproviders.email. This mailbox is not configured on local SMTP server (Exchange 2003). Hence cannot send email via Exchange as open relay is turned off; as it should be.

Solution

Outgoing email address should be configured to local.user@mycompany.com -an active local mailbox. Test that you can access local.user mailbox either through Outlook Web Access or Outlook client.

SharePoint Event Id 5214

 

Event Type: Error

Event Source: Windows SharePoint Services 3

Event Category: Databaseclip_image001

Event ID: 5214

Date: 10/16/2008

Time: 8:43:58 AM

User: N/A

Computer: SHAREPOINTSERVER

Description:

Insufficient SQL database permissions for user ” in database

‘SharePoint_Config’ on SQL Server instance ‘SharePointDataBase’. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object

‘proc_putPendingDistributionList’, database ‘SharePoint_Config’, schema ‘dbo’.

This is a known issue and can be resolved with the August 2008 cumulative update.

1. Windows SharePoint Services 3.0 hot fix package

2. SharePoint Server 2007 hot fix package

Thanks to Lambert Qin from Microsoft Online Support on Eggheadcafe

Crpyt32 Error

 

clip_image001

Event Type: Error
Event Source: crypt32
Event Category: None
Event ID: 8
Date: date
Time: time
User: user name
Computer: computer name
Description:
Failed auto update retrieval of third-party root list sequence number from:

 

<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt> with error: The specified server cannot perform the requested operation.
For more information, see Help and Support Center at http://support.microsoft.com.

RESOLUTION

To resolve this behaviour, you must connect to the Internet or turn off the Update Root Certificates component. To turn off the Update Root Certificates component, follow these steps:

1.

In Control Panel, double-click Add/Remove Programs.

2.

Click Add/Remove Windows Components.

3.

Click to clear the Update Root Certificates check box, and then continue with the Windows Components Wizard.

Reference Microsoft Support KB

Sharepoint 2007 breadcrumb includes default.aspx

Are you seeing default.aspx after Pages in your SharePoint breadcrumb navigation?

I found a simple fix for this problem in MOSS, modify the master page.

Open the master page and look for PlaceHolderTitleBreadcrumb

Change SiteMapProvider="SPContentMapProvider" to

SiteMapProvider="CurrentNavSiteMapProviderNoEncode"

To quote from my reference

When you’re creating a new Page Layout, make sure you override the Title Breadcrumb with something that uses the CurrentNavSiteMapProviderNoEncode provider.

Heather Solomon has written a great post detailing the behaviour of out of the box page layouts breadcrumbs. She has also linked to other resources for how to modify and use the breadcrumb.