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

Posted on 2004-11-25
Medium Priority
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
  • 2
LVL 11

Expert Comment

ID: 12675196
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: http://support.microsoft.com/default.aspx?scid=kb;en-us;325023

Author Comment

ID: 12675324
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

WeHe earned 2000 total points
ID: 12675405
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

809 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