.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Express to Standard upgrade

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
I have SQL Server 2005 Express that was installed with SharePoint Server 2007. I'm trying to upgrade it to SQL Server 2005 Standard edition and it gives this "Edition Change Check (Warning)" message:

"To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."

I tried "setup skuupgrade=1" from the command prompt, but it's giving me the same message.

Can someone tell me how to correctly make the upgrade?


View Complete Post

More Related Resource Links

Upgrade SQL Server 2005 Express 32-bit SP1 to SQL Server 2008 Standard on a 64-bit Server for use wi


When installing & configuring MOSS 2007 the default settings were choosen. So now when we try to access the SSMS I get a message "The evaluation period has expired. Please buy the product at the following url.". I do have a product key for SQL Server 2008 standard but when I am trying to perform a edition upgrade it doesn't detect the SQL Server Instance "OFFICESERVERS" so I am unable to upgrade the server. Because of the limitation in size we are unable to create new doc libraries or pages on the SP site.

Here are the details of the environment:

OS : Windows Server 2008 Standard SP1 64-bit

MOSS 2007 version :, Current License : Office SharePoint Server with Enterprise Client Access License

Database : SQL Server 2005 Express SP1 32-bit

SQL 2008 Upgrade Standard to Enterprise: Fail

I'm trying to upgrade an existing SQL Server 2008 SP1 Standard Edition to Enterprise.  Running the enterprise edition maintenance->Upgrade Edition wizard first got me the dreaded "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Eventually, I found an entry on Connect that mentioned closing all other windows and ensuring that the installer has the focus and this got me past that error.  Now that I can run the edition upgrade through to successful completion, it's not actually doing anything. Edition still reports as "Standard" and enterprise features such as "Compress Backups" do not work. I've run the upgrade twice and restarted the system to no effect. Before I do a "Rip and Replace" does anyone have any ideas on how to actually get the edition upgrade to work? Steve G. OS:    Windows Server 2008 R2 DB:    Product: SQL Server Standard Edition (64-bit)   Version: 10.0.2531.0 P.S. Just in case someone asks, yes, I did follow the instructions located here.

Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS

Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in

Problem with upgrade from SQL 2008 Express to SQL Server 2008 Enterprise

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

2005 Enterprise upgrade to 2008 Standard?

We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

Upgrade SQL 2005 standard Runtime edition to SQL 2005 standard edition full version

We have a MS SQL 2005 standard edition runtime license. The SQL Server Runtime license is a license that lets an independent software vendor (ISV) embed the complete SQL Server code into a solution for use only by the ISV application. The customers of the ISV cannot use this SQL Server product to run other applications or to develop new applications, databases, or tables. Now we want to add a new database to the SQL. We know that we have to buy a full version of SQL 2008 standard edition. But the question is: How can we add a new database to the existing SQL. Do we have to uninstall SQL runtime license and install the full version and migrate the existing databse or can we change the key and add new databases to the SQL server?

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Upgrade Desktop Engine (MSDE 2000) to standard Edition 2000

Hi All,   I need to upgrade from MSDE to SQL server 2000 Standard Edition how can we proceed with this. I am new to this and any help will highly appreciated. What are the things i should take care before going to this version up gradation ?

Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1

Name: Microsoft SQL Server 2005 Tools Hello, I am having a problem when trying to add the Client Components to an existing installation of SQL 2005 Standard Edition SP1 running on Windows 2003 Standard. The server was originally built with SQL 2005 Standard Edition and had SP1 installed at a later date. I am using the CD that SQL was originally installed with which is not a service packed copy of SQL. The reason given when clicking the details button is as follows: Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Any help would be greatly appreciated. Regards Steve

upgrade standard to enterprise MOSS 2007

When installed MOSS 2007, we provided the key for standard edition. Now we have to Install and configure Excel Calculation Services and full features in MOSS 2007. it is possible? If not support for standard edition how can we upgrade enterprise edition. we have a Enterprise key also.

SQL 2005 Express Edition with Advanced Services - Upgrade SP3

Hi On my Windows 2003 server, I have SQL 2005 Express Edition with Advanced Services -  2005.90.3042.0 I need to upgrade to SP3. I downloaded the  SQL 2005 Express Edition with Advanced Services with SP3 and ran it. It has an error: UpgradeAdvisor returned -1 Please help

Failed to upgrade SQL 2K5 Express to Enterprise: Service 'MSSQL$OFFICESERVERS' could not be starte

Hello, I have a standalone SharePoint Server 2007 with SQL Server 2K5 Express and today I upgrade the SQL 2K5 Express to Enterprise with the command: setup.exe SKUUPGRADE=1. At the last, the wizard give me a error dialog saying the following error.  I search the Internet for half a day but in vain. Hope you can show me some idea. Thanks. TITLE: Microsoft SQL Server 2005 Setup------------------------------ Service 'MSSQL$OFFICESERVERS' could not be started. Verify that you have sufficient privileges to start system services. The error code is (1067) The process terminated unexpectedly. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=1067&EvtType=sqlsetuplib%5cservice.cpp%40StartServices%40sqls%3a%3aService%3a%3aStart%40x42b  Hope Helpful | Xiaofeng Wang | http://www.leoworks.net

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

Upgrade from SQL Server 9.0.2047 (Express 2005 SP1 I believe) to SP3


I am running the version of SQL I listed in the title and like I said, I believe it is SQL Express 2005 SP1 and I just want to upgrade to SP3.  I tried installing it via Microsoft Update, but that failed without giving me any detail as to why.  When I try to run the SQL Exp 2005 SP3 installer (SQLEXPR.EXE) it just acts like it is going to install a new instance of it.

I saw a post about an unattended upgrade, but frankly I'm not very familiar with that and not really comfortable with doing it.  Is there not an installer I can run that will just upgrade to SP3?

Thanks to anyone who can provide some assistance for me, I appreciate it.

Using SQL 2008 Standard R2 instead of SQL 2008 Express Edtion


Hi Folks, I would like some advice if anyone else has actually tried....

I have production SBS2008 Premium Server on an HP Proliant ML350 G6, which has a live WSS site(s) based on CompanyWeb. I have run the Pre-Upgrade Checker and it has only flagged up 1 issue - the DataBase size (over 4GB) and uses Windows Internal DB.

We have purchased a copy of SQL 2008 R2 Standard with the intention of using this rather than SQL 2008 Express Edition R2, as our actual Content DB is 17GB and grows daily with new documents being added to the Library by users.

I am slightyly unclear on some additional steps I may need to take at STEP 6 in the Technet Guide (959273) detailing the step-by-step guide to migrating from WSS 3 to SPF 2010 on the SBS2008 box.

As I do not wish to use SQL Express Edition 2008 R2 SP1 on my SBS box, and use the Full SQL product, should I just substitute the creation of a named instance called "Express" using SQL Express Edition Management Studio, by installing the full SQL 2008 Standard R2 and create a named instance to use?

In short, I want to follow the migration Guide substituting the use of SQL 2008 Express for the Full SQL 2008 Standard R2 Product.

In theory, I believe this should not be a big issue, however I am a bit wary considering this is a Live Production Installation.

The real bummer is I don

How do I upgrade and overlay SQL Server 2005 Express with SQL Server 2008 R2


We are upgrading SQL server2005 Express to SQL Server 2008 R2.  We want to replace 2005 Express with 2008 R2 on existing system.  We have lots of questions about how to perform the upgrade safely and pull in our existing databases.  The existing database files are in C:\Program Files\Microsoft SQL Server\MSSQL.1.  Also, we'll want to use the existing instance name to avoid having to reconfigure all of the installed clients at our user's workstations.

Should we uninstall the 2005 Express version first?  Will that keep the existing databases on the system?

Or can we install 2008 R2 while the databases are live under the 2005 Express, or should we shut down 2005 Express first?

Will  2008 R2 use the same data folder or create a new one?  If it uses the same folder will it automatically recognize our existing databases?  If it creates a new one, I suppose we can use the migration Wizard.


Thanks for any help....


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend