Can I install the SQL 2005 Express beside SQL 2000 server to the same computer?

Hello,

Sorry for my question, I know, that there were several topics about sql 2000 vs SQL 2005, I read all them but unfortunately I haven't got the correct answer. I must install my intranet application that uses asp.net 2.0 and SQL 2005 Express to a Windows 2003 server with SQL 2000. It is possible to install SQL 2005 Express beside the 2000 server? It is very important, because I have no possibility to test and that Win2003 server there are a few programs that use SQL 2000. What will happen with the 2000 databases and their programs if I install the 2005 Express to the server? They will work fine with 2000 and my application will work with 2005?

Or instead it should I configure my application to use 2000 capable connentionstrings?

Keeping it short and simple, the answer isYes

Regards

|||Thanks|||

Following on from that question, how do you connect to the databases?

I currently have SQL2000 and connect using localhost in the connection string.

Now that I have SQL2005 Express installed alongside it, what do I use for that?

Cheers
pie