SBS 2003:  Fixing http://companyweb after SQL installation was done wrong...

Posted on 2004-11-25
Last Modified: 2010-04-19
Hi All,
My client's SBS 2003 box and domain was working beautifully.  A software vendor had to install SQL Server for an app the client purchased.  When they installed SQL, the inadvertently chose not to upgrade MSDE and instead installed a new instance of SQL.  My company web (and most related processes) have stopped working.

Attempting to load companyweb in the browser produces only the following text:  "Cannot connect to the configuration database."

How do I fix this problem without breaking the SQL Server app installed by the software vendor?  Can the current SQL Server be used to "run" the msde databases that were running behind the scenes before?

Question by:colepc
    LVL 11

    Expert Comment

    yes, you can use the SQL Server instead the MSDE (MSDE is a kind of a limited SQL Server) if you upgrade correctly.
    look here:;en-us;325023

    Author Comment

    Thanks.  I was aware that I can upsize the databases from msde to sql. However, the essential question is, how to resolve the condition described above.  Any ideas?
    LVL 11

    Accepted Solution

    create an sql instance wich has the same name as it was under MSDE.
    try to attach the database file from MSDE to this instance.

    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

    Join & Write a Comment

    It is a known fact that servers reach the end of their lives. Some get there quicker than others, based on age, manufacturer, usage and several other factors. However, if your organization has spent time deploying Microsoft's Active Directory server…
    I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now