Can SQL Server 2005 and Sql Server Express both reside on server?

Hello
1)How can you make Sql Server 2005 and Sql Server Express both be registered
servers on the same server?
2)What do you do if when you start the Sql Server Express "service" and it
always fails with an error message and it's icon remains red when the regular
Sql Server runs as expected and its icon remains green?1) Yes.
2) I would look at the error message and try to figure out what was going
wrong? Have you checked the Event Log?
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"winlin" <winlin@.verizon.com> wrote in message
news:32007D2E-A86A-4CC9-A3B7-2D122F619E4C@.microsoft.com...
> Hello
> 1)How can you make Sql Server 2005 and Sql Server Express both be
> registered
> servers on the same server?
> 2)What do you do if when you start the Sql Server Express "service" and it
> always fails with an error message and it's icon remains red when the
> regular
> Sql Server runs as expected and its icon remains green?

Can SQL Express 2005 & MSDE reside on the same box?

Is the installation of MSDE and SQL Express 2005 on the same computer a supported configuration?

Many thanks

Yes, you can run Express and MSDE/WMSDE in the same machine using different instance names.

Can SQL 2000 and WID coexist

My question is can the new version of MSDE (Windows Internal Database or SQL Express) reside on the server along with SQL 2000 without causing problems? We cannot upgrade the SQL 2000 because of an older application that doesn't work with SQL 2005. Currently we run WSUS 2.0 using MSDE and have no problems.

See replies to your similar post in the Getting Started with SQL Server forum.

Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).