Upgrade SharePoint SQL Express to Standard or Enterprise

Source : Todd Klindt’s SharePoint Admin Blog

Microsoft so very graciously provides a free version of SQL 2005, SQL Express, with MOSS. If you install MOSS using the Basic option or Single Server under Advanced you get SQL Express automatically. So what if as a budding newbie SharePoint admin you chose the Basic option, but now as a wise aged SharePoint admin you’ve seen the error of your ways and want to use a more respectable version of SQL for your SharePoint backend? You’re in luck. In this blog post I’ll walk you through upgrading SQL Express to SQL Standard or Enterprise.

First thing you need to do is get a copy of SQL 2005 Standard or Enterprise. Which version you choose depends on the redundancy and availability you want. Either will upgrade from Express. After you have your media you can start the install. This step is important as you have to pass the setup program a parameter to let it know you’re doing an upgrade. To upgrade use the command setup.exe SKUUPGRADE=1. It should look like this:

The setup should kick off and it won’t give you any indication that you passed it a parameter. Never fear, it will come up later. When the setup gets to the instance selection make sure you don’t accept the default instance and you choose the SQL Express instance. First click Installed Instances:

Then choose the OFFICESERVERS instance from the list and hit OK:

Your next screen should confirm that it found SQL Express:

If you click the Details… button you’ll see that the setup confirms that SQL Express can be upgraded. This step is optional.

At this point you can Close the box and hit OK until the setup is finished. After the setup is finished you’ll want to apply SP2 for SQL 2005 and any post SP2 patches that are available. I don’t know if it’s required but I always do an IISRESET after this to make sure that SharePoint reconnects properly to SQL.

That’s all there is to it. Once you are using full SQL you have quite a few more options available to you like log shipping, database replication, SQL Profiler and more. If you have any questions about how to leverage those tools with SharePoint, leave me a comment and let me know.



Try your Reports Before Publishing it

I’ve came a cross a site that gives you an option to publish your reports online and see it working before adding it to your site try it. It’s An Amazing Idea



Report Surfer is a community site for users to upload, share and run sample reports built on Microsoft’s SQL Reporting Services platform

Integrating CS2007 with Moss 2007

So, if you have been wanting waiting to use Office SharePoint Server 2007 in conjunction with Commerce Server 2007, this is the whitepaper for you.


This document covers the topics needed to take Commerce Server data and services and make them visible in portal sites based on Office SharePoint Server 2007. Samples are provided to show how to make custom Web parts that access the Commerce Server APIs.

Microsoft Office 2010

Microsoft released some information about SharePoint 2010 and Office 2010, this is conslidated list with information released till now