Sharepoint Foundation reached DB limit on express. Upgrade express to standard (2008 - 2008R2)

Posted on 2011-04-29
Last Modified: 2012-05-11
We started a project to test sharepoint foundation 2010 to see if it fit our needs. We went full boar on it and reached the DB limit for the express version that came with foundation. (Basic Install 4GB). Unfortunately we put it into production. I paid and opened a support ticket with MS and spent two hours upgrading to Sharepoint Standard.. However it failed because of db rights and when I asked the MS tech if this would even solve our 4gb limit problem he said.. NO you have to upgrade sql from express..
 Now we need to install SQL 2008R2 standard edition. During the installation in the test environment I get SQL Server 2008 R2 Feature Upgrade Failed. The specified edition upgrade is not supported. (Using the upgrade feature in the SQL Install package) I did run the System config checker  prior and all was ok except that I get a warning that .net is not connected to the internet (test environment is not). During the installation of tools I  did get an error message that you server needed to be rebooted which I did and did not get on the next install. However the installation does not continue and gives the edition error.
 I have read the MS documents on upgrade paths and everything seems to be a supported upgrade path. Foundation is running on a Windows Server 2008R2 running under HyperV.

Any help would be greatly appreciated.
Question by:bob13031
    1 Comment
    LVL 5

    Accepted Solution

    1) Install a SQL-Server 2008 Standard edition on seprate VPC/ box.
    2) Attach you express db to this machine.
    3) Change the connection string in the registry.

    HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\configdb

    4) You can get this from code as well :-

    RegistryKey key = Registry.LocalMachine.CreateSubKey(@"SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\configdb");
    DSN = (string) key.GetValue("DSN");
    SQLServerInstance = new string[]
    this.DSN.Split(new char[] { '=', ';' })[1]

    WARNING : Do not make any changes in the registry without taking proper backup


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video discusses moving either the default database or any database to a new volume.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now