CODEWITHSUNDEEP
visual-studiovisual-studio-2008sql-server-2005sql-server-2008visual-studio-2005
Mike
Mike

Reputation: 6050

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

Upvotes: 0

Views: 3228

Answers (4)

Mike
Mike

Reputation: 6050

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

Upvotes: 0

Alex J
Alex J

Reputation: 10205

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.

Upvotes: 1

Eric J.
Eric J.

Reputation: 150108

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.

Upvotes: 3

AaronLS
AaronLS

Reputation: 38367

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.

Upvotes: 1

Related Questions