Archive for March, 2009

SharePoint Infrastructure Updates & SP1

March 30, 2009

After a clean installation, you can install SP1 without running the Configuration Wizard. Microsoft have an excellent blog outlining the order.

Links to updates:

Infrastructure Update for Microsoft Office Servers (KB951297)x86

Infrastructure Update for Microsoft Office Servers (KB951297)x64

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)x86

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)x64

“For reference the following products require the following updates to be applied.

If you are running SharePoint Server 2007 you should:

  1. Install Windows SharePoint Services 3.0 Service Pack 1 (SP1) if you haven’t already
  2. Install 2007 Microsoft Office Servers Service Pack 1 (SP1) if you haven’t already.
  3. Install the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695).
  4. Cancel out of the “SharePoint 3.0 Products and Technologies Configuration Wizard”. (You CAN run the wizard if you want. It will just save you time if you run it once at the end.)
  5. Install Infrastructure Update for Microsoft Office Servers (KB951297)
  6. Run the “SharePoint 3.0 Products and Technologies Configuration Wizard”.”

Lessons Learned from VMWare – SharePoint Stand Alone Machine

March 26, 2009

Main points when you’re starting a VM using an ESX server, SharePoint 2007 WILL NOT INSTALL if it does not have at least 1GB memory allocated to it.

It will fail over step 8 of 12 in the Configuration Wizard.

If you get an error stating that “failed to create sample data”, you need to update Component Services.

To do this, configure the security settings for the Microsoft Distributed Transaction Coordinator (DTC) to use the Allow Remote Clients setting. To do this, follow these steps:

  1. Click Start, point to Administrative Tools, and then click Component Services.
  2. In the left pane of the Component Services snap-in, expand Component Services, and then expand Computers.
  3. Right-click My Computer, and then click Properties.
  4. Click the MSDTC tab, and then click Security Configuration under Transaction Configuration.
  5. Under Security Settings, click to select the Network DTC Access check box, if it is not already selected. Then, click to select the Allow Remote Clients check box
  6. Click OK.
  7. When you receive the message that states that the DTC service will be stopped and restarted, click Yes to confirm that you want to continue.
  8. Click OK when you receive the message that the DTC service was restarted.
  9. Click OK

I would recommend that you install SQL Server 2005 as a dedicated server too, the integrated SQL Express 2005 edition may be great for a small demo environment, but if you want to scale it up, it’s a nightmare to deal with.

Make sure at each step, WS2003 install, SQL Server and SharePoint that you run Windows Update, even in a Development area.

Alternatively, use Microsoft’s VHD images that they have on offer, at current time of writing, the image is AOK until Jan 2010 if you licence it. See this great blog for more information.

Toodle pips folks.

Creating Virtual Earth Map using SharePoint Designer

March 23, 2009

If you have a massive ERP or CRM system with hundreds of customers or client addresses, wouldn’t it be nice to see a lovely map of where they are located… anywhere in the world using Microsoft Virtual Earth?

SharePoint Designer is an incredible tool to use!

If you want to display a map underneath a display list which contains contact information, follow the step by step instructions given on this blog:

Multiple addresses are plotted using LON and LAT co-ordinates, so that involves quite a bit if work. You can re-use the list as given in the link below, create a lon and lat column and generate the co-ordinates using

Of course this is a long winded way to plot multiple data, you can simply change the parameters around to use address, zip code etc. instead.

Follow this blog to get detailed instructions on the “how to”. I found it easier to create a simple aspx page with  no master page first. Then create a page view to link up from a “sharepoint” page to the unbranded page. I found that with custom design pages javascript may make the map in a strange funky format.

Batchgencode was a great help.

Please note, there are codeplex webparts available for virtual earth.. but this is the nice, handcoded version if you want to know the nitty gritty. Link to Codeplex.

Unable Add/Remove Visual Studio 2008

March 20, 2009

I came across a problem where I could not change, repair or remove Visual Studio 2008, running on my client machine. “A problem has been encountered while loading the setup components. Canceling setup.”

This is caused by Security Update for Visual Studio 2008 (KB952241), remove this update, restart the computer and try uninstalling it again.

Useful to know!

Content Types

March 19, 2009

Inheritance is incredibly it comes to Content Types. Some may say that it’s vital the Content Types are deployed as features rather than used Out of The Box.

I, however, would recommend that all content types are managed at all times from the root home of your site collection. I made a silly mistake where I added custom columns to a document library that had content type management, this in effect, broke inheritance from home to sub sites and inheritance cannot be filtered upwards.

When you amend content types at library level, it cannot be updated in any form from the home root. You either need to re-build the library or remove the content type and re-apply it. Also, when you remove the content type, you must remove all instances of it first.

I have been going through an exercise of re-attaching document libraries the long way, yes, manually. It gives me far better control of my documentation and I am becoming an expert in knowing what not to do when it comes to SharePoint libraries 🙂

Further information about content types can be found here:

Server Farm Maintainence

March 10, 2009

Most excellent blog was posted and wanted to re-iterate the importance of keeping your server clean.

In summary:

– Install, verify, update SharePoint software.

– Event logging, check event logs and rectify problems, take a farm back up in Central Administration

– SQL Maintenance plans including “Check Database, Shrink Database, Reorganize Index, Clean up the History as well as Defragmenting your databases”

– Document your install!

Are you looking for SharePoint help?

March 9, 2009

I can certainly help, email me at if you are looking at getting SharePoint, have SharePoint and cannot get much from the product or general SharePoint consultancy.

We have a dedicated account managers, sales consultants, an incredibly talented senior technical consultant, myself as the SharePoint consultant. We are a Microsoft Gold Partner and fully SharePoint Certified. If you have Software Assurance, please contact us.

Further details can be found on the Software Assurance page: or contact me for further details at

We can help businesses in the South East of England, Berkshire, Buckinghamshire, M4 and M25 corridor!

Installing Windows SharePoint Services 3.0 on a Server Running Windows Small Business Server 2003

March 2, 2009

Go to for more information, yet to implement on a SBS but will edit this post once I have done to report my findings.