Skip Ribbon Commands
Skip to main content

Quick Launch

Todd Klindt's home page > Todd Klindt's SharePoint Admin Blog > Posts > Upgrade SQL Express to Standard or Enterprise
November 25
Upgrade SQL Express to Standard or Enterprise

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.

tk

 

Comments

PERFECT...

BEAUTIFUL ANSWER! JUST WHAT WE NEEDED!! THANK YOU!! I´m sure many people don´t know exactly what kind of SQL is installed with the basic option. Thank GOD it can be upgraded!!!
 on 12/10/2007 3:34 PM

You are my man!!

thanks god my friend!! you save my life!! mil gracias amigo
 on 12/11/2007 8:16 AM

Re: PERFECT...

Always glad to help.  One thing I meant to mention in the blog post was that while MOSS bundles SQL 2005 Express, WSS does not.  WSS uses a product called "Windows Internal Database" or WID.  I don't know of any way to upgrade WID to any flavor of SQL.  The good news is that WSS is pretty simple, so you can just reinstall it with SQL and use the WID database files.  If there's demand I could write something up on it too.

tk
Todd O. KlindtNo presence information on 12/11/2007 9:19 AM

Re: You are my man!!

¡De nada!  Comments like this always remind me why I spend the time writing these blog posts up.  :)

tk
Todd O. KlindtNo presence information on 12/11/2007 9:20 AM

Upgrade WID to standard SQL

A light from the sky.
I'm using WID for WSS and with a standard SQL installed currently on the system. I'd like to upgrade WID to standard SQL. Appreciate you very much in advance.
 on 12/24/2007 1:20 AM

Re: Upgrade WID to standard SQL

I may have a way to do this, but with the holidays I won't have a chance to try it for a couple of days.  If don't want to wait you could also just use STSADM -o backup to back your site collections up, reinstall WSS using SQL then use STSADM -o restore to restore your content.  Since WSS doesn't have SSPs or anything it can be moved that way very easily.

tk
Todd O. KlindtNo presence information on 12/24/2007 8:04 AM

parameter is case sensitive

Note that the parameter must be type exactly as shown (not skuupgrade=1).
 on 1/3/2008 3:54 PM

EUREKA!!

Thanks for the help. We actually have a previous named instance that we HAVE to upgrade from Express or we're screwed. You're so money and you don't even know it, baby!
 on 1/9/2008 3:08 PM

Re: EUREKA!!

Excellent.  Glad to hear it.  Comments like that make me glad I post this stuff.

tk
Todd O. KlindtNo presence information on 1/11/2008 1:13 PM

No opportunity to upgrade instance

I am using SQL 2005 Developer Edition.  I have been able to upgrade SSMS SSRS clint components, etc.  I do not get the option to upgrade an instance of any databases during the install.  Any idea where I am going wrong?
 on 1/16/2008 9:15 AM
1 - 10Next

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Today's date *

Select a date from the calendar.
Please enter today's date so I know you are a real person

Twitter


Want a message when I reply to your comment? Put your Twitter handle here.

Attachments

 

 Please Support my Sponsors