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

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?

Thanks,
Terry
colepcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

WeHeCommented:
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
0
colepcAuthor Commented:
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?
0
WeHeCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.