November 2011 SharePoint Technical Rollup

SharePoint Technologies News

NetHope uses SharePoint to help 33 Leading Humanitarian Organizations share best practices.

When natural disasters occur, the ability to coordinate relief efficiently and effectively is critical. Responders are faced with a challenging environment that includes increasing complexity of inter-agency coordination, damaged and limited communications infrastructure, outdated or paper-based mapping/topography information, and difficulty in disseminating information quickly (both between the various response participants and the public). These challenges have been compounded by the increasing frequency and severity of natural disasters as well as deepening global inter-dependencies occurring in the last decade.


OpsVault — Operate and Optimize IT

Microsoft Premier Support UK – Site Home – TechNet Blogs ttp://

SharePoint Technologies Documents

  • Hybrid SharePoint Environments with Office 365
  • Are you evaluating how Office 365 fits into your overall communication and collaboration strategy plan, both today and into the future? Specific to SharePoint, are you planning for full cloud adoption within your firewall, or will you begin your move to the cloud with a mixed deployment across SharePoint environments – both on-premises and online within Office 365? To provide insight in this area, we’re excited to announce the new “Hybrid SharePoint Environments with Office 365” whitepaper.

SharePoint Technologies Downloads

October 2011 CU for SharePoint 2010 has been released

The product group have released the delayed August 2011 Cumulative Update for the SharePoint 2010 product family. Be aware that the October Cumulative Update for SharePoint 2010 is a Post-SP1 hotfix. That means that you should ensure that SP1 is installed before the October CU.

Microsoft Internet Information Server Download CENTER

This is your single source for finding Microsoft Internet Information Services tools, samples, extensions, filters and modules created by Microsoft and the IIS community.

SharePoint Technologies New KB’s

Windows SharePoint Services 3.0

The thesaurus is not applied when you perform a search after you type text in the "All of these words" text box or in the "The exact phrase" text box in SharePoint Server 2007

You cannot delete certain site collections in Windows SharePoint Services 3.0

Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): August 25, 2009

Description of the Windows SharePoint Services 3.0 hotfix package (Sts-x-none.msp): December 27, 2009

Description of the Windows SharePoint Services 3.0 hotfix package (Sts-x-none.msp, Wssmui-en-us.msp): February 23, 2010

Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (WSS server-package): April 30, 2009

Error message when you try to manage a site collection in Windows SharePoint Services 3.0 or in SharePoint Server 2007: "User cannot be found"

Description of the Windows SharePoint Services 3.0 hotfix package: February 22, 2008

How to use the new "renamesite" operation to change the URL of a host-named site collection in Windows SharePoint Services 3.0

One-time timer jobs in Windows SharePoint Services 3.0 or in SharePoint Server 2007 are delayed by at least one hour when the jobs are scheduled to occur during daylight saving time (DST)

When the database status for a Windows SharePoint Services 3.0 site collection has been set to offline, you may be unable to find items that are saved in the site collection

Error message when you try to connect to a site in a Windows SharePoint Services 3.0 site collection: "HTTP 500 – Internal server error"

Error message when you try to connect to a site in a Windows SharePoint Services 3.0 site collection after you configure a document library to inherit permissions: "HTTP 500 – Internal server error"

Issues that may occur when you use the volume shadow copy service (VSS) reference writer in Windows SharePoint Services 3.0

A file that is attached to an e-mail message is not put in a Windows SharePoint Services 3.0 document library

Error message when you try to install a feature in Windows SharePoint Services 3.0: "The ‘UserSelectionMode’ attribute is not allowed"

The Web File Properties dialog box displays incorrect properties for a document that is saved in a Windows SharePoint Services 3.0 document library

You cannot disable VSAPI scans when you schedule manual scans of content in SharePoint Server 2007 and in Windows SharePoint Services 3.0

A default column value is saved to a document regardless of the content type of the document in a Windows SharePoint Services 3.0 document library

Windows SharePoint Services 3.0 does not comply with daylight saving time in Western Australia for the years 2006 to 2009

One or more custom programs do not finish successfully when you run multiple custom programs that use the BreakRoleInheritance function in the Windows SharePoint Services 3.0 object model

You cannot select the values for a custom field when you try to edit the properties on the FldEditEx.aspx page on a Windows SharePoint Services 3.0 Web site

Microsoft Office SharePoint Server 2007

Description of the Office SharePoint Server 2007 hotfix package (Dlc-x-none.msp): December 15, 2009

Error message when you access an Office SharePoint Server 2007 site by clicking “View My Site” in Office Outlook: "User not found"

The Search Results page does not display the Items in a shared folder in Office SharePoint Server 2007

No search results are returned when you search for content in an Office SharePoint Server 2007 site that contains German umlauts in the URL

Description of the Office SharePoint Server 2007 hotfix package (Offfiltx-x-none.msp): December 15, 2009

You have to wait two hours for RSS Viewer Web Part to display the changes in an Office SharePoint document list

The Copy option in Office SharePoint 2007 site manager is not hidden for users who are not listed as site collection administrators

You experience search related errors after you enable "Use a dedicated web front end computer for crawling" setting in Office SharePoint Server 2007

No results are returned when you search for German compound words or for German compound names in SharePoint Server 2007

A document library or a list is not returned in the search results when you use an SQL query to sort search results in SharePoint Server 2007

Some documents are not returned in the search results when you search for content that contains particular Chinese Traditional characters in SharePoint Server 2007

Users who are color-blind cannot distinguish between the red presence icons and the green presence icons on a SharePoint Server 2007 site

Sites that require forms-based authentication or cookie-based authentication are not crawled in SharePoint Server 2007

No documents are returned in the search results when a user searches for Lotus Notes content in SharePoint Server 2007

A URL that contains an extra slash mark may take longer to open on a server that is running SharePoint Server 2007

Complex remote links are not crawled when the links are in the same SharePoint Server 2007 portal

You cannot crawl case-sensitive Web content in SharePoint Server 2007

SharePoint Server Foundation 2010

SharePoint 2010: Filter Web Parts added to site pages are not visible

SharePoint: Impact of Duplicate Key error during site import or Content Deployment

SharePoint Server 2010

RSS Viewer Web Part does not update or refresh asynchronously

SharePoint 2010: Crawls get paused if the crawl components temp folder is deleted

SharePoint 2010: Access Denied when accessing a page with unique permissions

SharePoint: Office client integration errors when no root site exists

"Changes could not be saved into the document" error message when you create a new site that is based on a saved site template from a SharePoint Server 2010 site that contains signed InfoPath forms

The Microsoft Knowledge Base (KB) article links are incorrect in the SharePoint Health Analyzer (SPHA) health report for the Simplified Chinese version of SharePoint Server 2010

"User modifications to the SharePoint content database" error message when you upgrade a SharePoint Server 2007 content database to SharePoint Server 2010

The Microsoft.Office.SecureStoreService.dll file installed by SharePoint Server 2010 cannot be found in the "Microsoft Shared\Web Server Extensions\14\ISAPI" folder

The Excel Services Application for SharePoint 2010 does not load or display workbooks

Error message when you delete a user in the source collection and then try to perform an incremental deployment in Microsoft SharePoint Server 2010: "Your changes conflict with those made concurrently by another user"

You cannot visit any site collection from an Office SharePoint Server 2007 content database after you attach the content database to a SharePoint Server 2010 environment

SharePoint 2010: Metadata field values not saved on imported sites

SharePoint 2010: Missing stored procedure error after installation of SP1

SharePoint Designer 2010

None this month

SharePoint Designer 2007

Description of the Office SharePoint Designer 2007 Cumulative Update server hotfix package (Fpsrvutl-x-none.msp): February 23, 2010




Digg This

SharePoint Intelligence & QuickStart Bootcamp Courses

font-family:”Times New Roman”,”serif”;
font-family:”Times New Roman”,”serif”;
margin-left: 0in;
margin-right: 0in;
margin-top: 0in;
font-family:”Times New Roman”,”serif”;
font-variant:normal !important;
font-variant:normal !important;
font-variant:normal !important;
font-variant:normal !important;
font-variant:normal !important;
font-variant:normal !important;
.wlwritereditablesmartcontent { behavior: url(#default#.WLWRITEREDITABLESMARTCONTENT_WRITER_BEHAVIOR) }
.auto-style1 {
display: inline;
font-size: 9.6pt;
border-style: none;
border-color: inherit;
border-width: 0;
margin: 0;
padding: 0;
.auto-style2 {
text-align: left;
.auto-style3 {
font-size: 9.6pt;

QuickStart Promo

Need a lot of training in a short amount of time? Bootcamps are an effective way to become an expert in one week! Bootcamp students receive a free Transcender, a Microsoft Test Voucher, as well as a catered lunch everyday. Check out our bootcamps below:

Windows Server 2008 Bootcamp

MS-MCTSW2008 – Upgrade from Windows Server 2003 to Windows Server 2008 Boot Camp (5 days)This course will provide you with the knowledge and skills to work with network infrastructure, Active Directory technologies in Windows Server 2008.

Microsoft SQL Server Bootcamp

MS-MCTSBIO8 – Microsoft SQL Server 2008 Business Intelligence Bootcamp (5 days) – Microsoft Business Intelligence is designed with IT manageability and cost effectiveness in mind, allowing for better management of critical data assets across diverse systems to ensure the integrity of information, spanning the desktop, datacenter, and cloud.

Windows 7 Bootcamp

MS-MCITPWIN7– Windows 7 Enterprise Desktop Support Technician Bootcamp (5 days) – This course provides students with the knowledge and skills to successfully install, maintain, and troubleshoot Windows 7 computers. Through practical labs, you’ll get invaluable experience with installation and upgrades, remote access, and the new desktop environment.

Exchange Server Bootcamp

MCITPEXCH – Exchange Bootcamp Design, Configure, and Manage (5 days) – Become an expert on configuring, managing and troubleshooting Microsoft Exchange Server 2010 as well as designing and deploying messaging solutions.

Follow on Twitter | Friend us on Facebook | Connect on LinkedIn

One of my favorite things about QuickStart is their involvement in the community from hosting Microsoft User groups at their facilities to building events like SharePoint Intelligence. You have to love a company like QuickStart who goes beyond selling their services to supporting the communities in which we all work and live.

QuickStart you guys ROCK, thank you…..



Restoring a Certificates Private Key without the CertReq

I had a client issue a CertReq awhile ago and forgot to publish this post from a SharePoint 2007 created IIS Virtual Server being used for Staging and when the WebApp was removed, the choice to delete the IIS Virtual Server was chosen though the Content Db was not.

Since IIS had lost the link to the CertReq and it had to be reestablished in order to mark the private keys as exportable… You can still use the Cert from the response but without the keys it’s not exportable to another server.

Best practice would be to use the Default IIS Virtual Server, since it should never be removed and on a system where there is not activity, import the response, export and protect with a password to be used again.

To assign the existing private key to a new certificate, you must use the Microsoft Windows Server 2003 version of Certutil.exe.

There are two ways to recover the certificate:


CERTUTIL is the built-in Command Line tool to administer a Windows 2003 CA from the command line. CERTUTIL has several switches for CA administration and Key Recovery.

KRT.EXE  The Key Recovery Tool (KRT.EXE) is a new tool which is part of the Windows Server 2003 Resource Kit Utilities. KRT is a GUI extension for the builtin Windows 2003 CA tool CERTUTIL. In this article, we will use the Key Recovery Tool (KRT).


  • 1. Log on to the computer that issued the certificate request by using an account that has administrative permissions.
  • 2. Click Start, click Run, type mmc, and then click OK.
  • 3. On the File menu, click Add/Remove Snap-in.
  • 4. In the Add/Remove Snap-in dialog box, click Add.
  • 5. Click Certificates, and then click Add.
  • 6. In the Certificates snap-in dialog box, click Computer account, and then click Next.
  • 7. In the Select Computer dialog box, click Local computer: (the computer this console is running on), and then click Finish.
  • 8. Click Close, and then click OK.
  • 9. In the Certificates snap-in, expand Certificates, right-click the Personal folder, point to All Tasks, and then click Import.
  • 10. On the Welcome to the Certificate Import Wizard page, click Next.
  • 11. On the File to Import page, click Browse.
  • 12. In the Open dialog box, click the new certificate, click Open, and then click Next.
  • 13. On the Certificate Store page, click Place all certificates in the following store, and then click Browse.
  • 14. In the Select Certificate Store dialog box, click Personal, click OK, click Next, and then click Finish.
  • 15. In the Certificates snap-in, double-click the imported certificate that is in the Personal folder.
  • 16. In the Certificate dialog box, click the Details tab.
  • 17. Click Serial Number in the Field column of the Details tab, highlight the serial number, and then write down the serial number.
  • 18. Click Start, click Run, type cmd, and then click OK.
  • 19. At the command prompt, type the following:

certutil -repairstore my serial# from item 17

Note: KRT works with a Microsoft CA. By default CertUtil defaults to using a CA and not the local Store. I haven’t tried to use the certutil -store command then using KRT this may work?


Technorati Tags: ,,

Site for Reviews of ThirdParty Software "" is an independent product directory that provides SharePoint end-users, developers and administrators with objective expert reviews and opinions on SharePoint web parts, applications and development platforms. With searchable product listings, ratings and reviews it will help you find the most suitable SharePoint product within the shortest time. You can browse by categories, vendors, platforms and other parameters.


SharePoint Reviews is not affiliated with any vendor and does not receive any commissions/compensation from product listings or reviews. All operating funds come strictly from advertising, which would be distinctly marked on our site.


There is always a place in my heart for a site of unbiased reviews on the growing number of third party products that exist in the market place. Registration is simple and will allow you to immediately start reviewing products…

I want to join Mike Fitzmaurice in saying: "Do the math: Third party Add-Ons are your friend" . In addition, if you remember when your only source of information on SharePoint were blogs then you know that it matters who writes the review….



SharePoint Search Enhancements available on Codeplex


SharePoint sites

You want to crawl the content on a particular site collection on a different schedule than other site collections.

Crawl only the SharePoint site of each start address

clip_image001Note: This option accepts any URL, but will start the crawl from the top-level site of the site collection that is specified in the URL you enter. For example, if you enter http://contoso/sites/sales/car but http://contoso/sites/sales is the top-level site of the site collection, the site collection http://contoso/sites/sales  and all of its subsites are crawled.

In the Crawl Configuration section, select one of the following:

Exclude all items in this path. Select this option if you want all items in the specified path to be excluded from the crawl.

Include all items in this path. Select this option if you want all items in the path to be crawled.

If you chose to exclude all items in this path. Otherwise, you can further refine the inclusion by selecting any combination of the following:

Follow links on the URL without crawling the URL itself. Select this option if you want to crawl links contained within the URL, but not the URL itself.

Crawl complex URLs (URLs that contain a question mark (?)). Select this option if you want to crawl URLs that contain parameters that use the question mark (?) notation.

Crawl SharePoint content as HTTP pages. Normally, SharePoint content is crawled by using a special protocol. Select this option if you want SharePoint content to be crawled as HTTP pages instead. When the content is crawled by using the HTTP protocol, item permissions are not stored. This means that all items that match a particular search query appear on search results pages, regardless of whether the user that initiated the query has access to those items. The purpose of this setting is to enable search administrators to crawl remote SharePoint sites that they do not have explicit control over and therefore cannot enforce that the domain account used to crawl those remote sites has been granted full-read permissions on those sites.

Remember why Codeplex is so cool all of the features / solutions on Codeplex have the source code available..




Technorati Tags: ,,

SSIS SharePoint List Adapters

Sometimes even the easy things can be hard… It doesn’t matter how many times I attempt to explain how to use the SSIS Adapters available on Codeplex with source code and documented on MSDN I seem to fail. So this time I will include pictures… However, this post assumes you have read the SharePoint List Adapter Readme and the MSDN article..

This example uses two Calendars; Calendar is the source and Calendar.MSDN is the destination

After Installation and Configuration of VS2008 you should be able to complete the following:

1. Drag a SharePoint List Source & a SharePoint List Destination from your toolbox image


2. Fill in the Properties of the SharePoint List Source and drag the green connector to the Destination

    • SiteURL – The URL for the primary site on which the list is found. Do not include any other subfolders or list paths, or the location of an .asmxfile.
    • ListName – The name of the SharePoint list, as seen on the SharePoint list page.
    • ViewName – The name of the SharePoint list view from which you want to retrieve data. You can use a list view to pre-filter rows and eliminate the need to add dynamic CAML queries to your package.

Example List Source SiteURL http://trex-si-11, ListName Calendar, ViewName Calendar


Example List Destination SiteURL http://trex-si-11, ListName Calendar.MSDN, ViewName Calendar

3. Next Map the Columns on the List Destination but do NOT Include ID if you want the Source to Create a Row on the Destination, Include an ID if you want the Source to Update the Destination..


The rules are:

  • Create a Row (Modification Batch Type). A row is created on the server when you select this batch type and do NOT specify an ID value for a given row of data. Any columns that are not included receive the default values or a NULL value on the server.
  • Update a Row (Modification Batch Type). A row is updated on the server when you select this batch type and You MUST specify the ID of an existing row. Only the columns contained in the data flow are modified. If you specify this batch type, but the data flow does not contain any updated rows, an error is raised.
  • Delete a Row (Deletion Batch Type). A row is deleted on the server when you select this batch type and specify the ID of an existing row. If you specify this batch type, but the data flow does not contain any deleted rows, an error is raised.

Execute the Task and if its green your good to go. However, the rules above mean that you will probably need more than one Data Flow to handle the different scenarios



The MSDN Article By Kevin Idzi and the Readme should pretty much explain all you need to know so I have to wonder why I am explaining it again, for everyone who did not know the references…




Technorati Tags: ,,

SharePoint Set Permisssions on Views and Columns

Folks ask all the time is there a way to set View and Column permissions on Lists. The answer is yes there are a couple of SharePoint solutions that do just that.

The first is SPViewPermissionSetting (Powered by Laurent Cotton Aka Suchii – Bewise) that allows you to choose what groups have access to specific views

The second is SPListDisplaySetting (Powered by Laurent Cotton Aka Suchii – Bewise) that allows you to select the columns that show up in the for new, display, and edit and to choose the group…

There are a few more on Codeplex like OfficeToolbox.SharePoint.Lists v1.0 that only allow you to lock down the column and not choose to allow groups to have different access.

Note: When using the SPListDisplaySetting and the OfficeToolbox.SharePoint.Lists v1.0 solutions at the same time your results will not be consistent, deactivate one while testing the other…



Ivan Sanders My LinkedIn Profile, My Blog, @iasanders, MVP

News SharePoint Technologies

Originally Posted 07/08/2011

Service Pack 1 for SharePoint 2010 Products is Now Available for Download

Service Pack 1 includes stability, performance, and security enhancements that are a direct result of your feedback. It is strongly recommended to install the June 2011 Cumulative Update immediately after the installation of Service Pack 1. The June Cumulative Update includes several important security and bug fixes that are not included Service Pack 1.

June 2011 CU for SharePoint 2007 and 2010 is Now Available for Download

The product group released the June 2011 Cumulative Update for the SharePoint 2007 and 2010 product family.

That’s Why I Use SharePoint

This week, we launched a new SharePoint website dedicated to inspiring everyday business users to do more with SharePoint 2010 by demonstrating how it can help make the work day just a little smoother.

Office 365: Move your My Sites, Team Sites, and Intranet Sites into the Cloud

Once you’ve seen what Office 365 can do, you’ll want more. For immediate cost savings, consider moving your My Sites, Team Sites, and Intranet Sites to SharePoint Online.

New Resource Centre: Best Practices for SharePoint Server 2010

Learn how to keep your SharePoint Server 2010 environment available and performing well by following best practices based on real-world experience

Introduction for Office 365 administrators

Read an overview of where and how to start managing the services and features in Office 365.

Try Office 365 for free for 30 days

Explore features, set up user accounts, and test drive Office 365. After 30 days you can convert your trial into a paid subscription.

Office 365: SharePoint Online Administration Resource Centre

Find SharePoint Online administration and planning information, including the SharePoint Online Administration Center Guide and the planning guides.

European SharePoint Conference 2011, 17-20 October, Berlin

This year’s European SharePoint Conference will take place in Berlin from 17-20 October



SharePoint Technologies

SharePoint Lifecycle Management Solution with Project Server 2010

The SharePoint Lifecycle Management Solution with Project Server 2010 provides a framework and guidance for managing SharePoint business requests and includes two white papers and a sample dataset.


SharePoint Technologies

Configuring a BI infrastructure: Hands-on labs

This series of articles gives you hands-on experience configuring the various business intelligence services available in SharePoint Server 2010.

SharePoint 2010 and Windows Azure Training Kit

Microsoft Internet Information Server


This is your single source for finding Microsoft Internet Information Services tools, samples, extensions, filters and modules created by Microsoft and the IIS community.


SharePoint Technologies

Office 365 Jump Start: Microsoft Office 365 Overview for IT Pros

On Demand

Watch the first video in the Office 365 Jump Start series for a perspective of the value Office 365 provides to organizations in terms of productivity, access, familiarity, security, control and reliability.

Office 365 Jump Start: SharePoint Online Overview

On Demand

Where do you start with SharePoint Online? Watch this video for a broad discussion of features and a demonstration of how these features can make organizations more efficient.

Office 365 Jump Start: SharePoint Online Administration

On Demand

Learn about the various aspects and roles to SharePoint Online Delegated Administration, and see a demonstration of various elements of Site Collection and Site Level ownership.

Office 365 Jump Start: SharePoint Online Extensibility & Customization

On Demand

Watch this fun and demo-rich Jump Start session where Matthew Burnett shows IT pros the power—and simplicity—of SharePoint Online development.

How Microsoft IT does Business Intelligence

On Demand

Learn how Microsoft IT manages and delivers scorecards to the masses at Microsoft with technical details and best practices about how they created a solution as part of the enterprise data warehouse strategy.

New KB’s

Microsoft SharePoint Designer 2010

SharePoint Designer 2007 workflow generated forms fail to complete tasks after upgrading to SharePoint 2010 with the following error: Cannot complete this action.  Please try again

SharePoint Designer 2010 workflows will remove back slashes in dynamics strings if the Workflow Actions uses lookup data and static text when the workflow executes.

Microsoft SharePoint Workspace 2010

You see a Print dialog box instead of a Web browser in SharePoint Workspace 2010 when you double-click to open a shortcut for a Web site

Microsoft Office SharePoint Server 2007

SharePoint 2007: Decimal values are incorrectly saved into the MSSDocProps table which affects the advanced search

Microsoft SharePoint Server 2010

How to use manual approval to override a workflow of type "Approval – SharePoint 2010" which is "In Progress"

SharePoint 2010: Only the Start address URL of a PHP based Web site content source is being crawled by FAST search connector

Microsoft SharePoint Foundation 2010

Access denied when deploying a timer Job or activating a feature from SharePoint 2010 content web application

Microsoft Windows SharePoint Services 3.0

Changing the impersonate value of the identity element in the web.config of a SharePoint web application is not supported



Technorati Tags: ,
« Previous Page