installing visual studio 2005 after 2008 already installed

I have a machine with VS 2008/Sql 2008 already installed. I now need to install an instance of vs 2005/Sql 2005 for two reasons.

The main reason is for reporting Services 2005. All of the report servers are sql 2005. Now to create a SSRS compatible with 2005 do I just need to install Sql Server 2005 and work with it in VS 2008 or do I also need to install VS 2005.

The second reason is the off-site team that I am consulting with do not want the project upgraded yet.

So without rebuilding the whole box is there a safe way to 开发者_运维知识库install VS 2005 on a box that already contains 2008?

Same question for Sql Server 2005?

Thanks

I have 2005 (VS/SQL), 2008 (VS/SQL) and 2010 (VS only) installed side by side and it works fine. However, it can become confusing exactly which version of SQL is which (if anyone has a good tip for that let me know). I didn't have any particular issues, just installed out of the box and it worked.

Having said that, the Virtual PC route that AaronLS recommends is worth considering.

I personally would use VirtualPC and install the SQL server in a virtual machine. You can use the Microsoft Loopback Connector to connect your local host machine to the guest machine.

VS and SQL Server 2008/2005 work fine side by side, and I believe you don't need anything special to make it work. You'll have to use an instance name that isn't taken for SQL Server, but that's about it.

Installing VS 2005 first and then installing Sql 2005 with the command switch SKUUPGRADE=1 seems to have done it.