Installation of SharePoint SP2 fails

During the update, you can run into the following exception:

Exception: System.Data.SqlClient.SqlException: Address Windowing Extensions (AWE) is not supported in this edition of SQL Server.
Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.

To solve the issue and be able to install the SP2 to your SharePoint Servers, you will need to disable the AWE option in the SQL server properties. If you like, you can switch it back on after the update.

Updated SDK

Microsoft has released a new version of the SharePoint SDK. Go and grab it 🙂

So what is new in the release?

WSS

  • Expanded documentation of backup and restore features
  • Complete documentation of Microsoft.SharePoint.Administration.Backup
  • New documentation of the administrative object model
  • Revised Web Part documentation
  • More migration support
  • Expanded and updated reference documentation

MOSS

  • Custom Federated Search Web Part with a Credentials UI
  • Federated Search SQL Server Connector
  • Federated Search HTML to RSS Connector
  • Federated Search Virtual Earth Map Connector

Next SharePoint – Microsoft SharePoint (Server) 2010

The next SharePoint Server will be “Microsoft SharePoint Server 2010”. No more Office in the server product names. That will make it much easier to talk about the products. We can forget SharePoint 14. Welcome SharePoint 2010!

You can read the announcement at the official SharePoint Blog.

The SharePoint Services will keep the name and have many new features. What exactly these features might be, is still in the dark 🙁

Microsoft Blog – Fix It

How often are you asked by family members or friends “I have a problem with my computer. Can you take a look at it?”

A couple of times I’ve been asked to fix a CD-Rom, which has disappeared from the explorer. In the device manager it had an error code 39. Instead of letting the other fiddle with registry settings, you can tell them to install the fix “CD drive or DVD drive is missing in Windows XP or Vista”.

Service Pack 1 for Microsoft SQL Server 2008

The SP1 has been released. You can download it here. (Release Notes)

Some changes to make the deployment easier:

  • Slipstream – You are now able to integrate the base installation with service packs (or Hotfixes) and install in a single step.
  • Service Pack Uninstall – You are now able to uninstall only the Service Pack (without removing the whole instance)
  • Report Builder 2.0 Click Once capability

How To get the default page from a website

This post is a follow up for my post “ Get default page Url”.

When you access an SPWeb through a URL in your browser, you will be redirected to the default page like home.aspx.

Each SPWeb has a RootFolder. And this SPFolder has a property “WelcomePage”. This property stores the relative path to the default page like “wiki pages/home.aspx”.

 1: SPContext.Current.Web.RootFolder.WelcomePage

Control Adapters

With a Control Adapter you can customize the rendering of an attached control. Certain control methods can be overridden with custom code, to make the control behave differently.

Some Control Adapters for SharePoint, which already exist: