views:

1796

answers:

2

I am told that SQL Server 2005 installation with BI tools and SQL Server 2008 with BI tools can't work together on the same computer. Apparently "some" things stop working. This was told to me by one of my team members. Since I'm new to SQL BI, I cant discount what he has said altogether and I dont want to install them both on my dev box and find out later that there is problem.

Has anyone here installed them both, used both sufficiently well and found it to be working fine?

Thanks.

+1  A: 

I'm not sure if this is your development system or the server... If its the server you can have side by side reporting services on the same server at the same time (though you use double the resources too). I am not sure why you would though; the reporting services 2008 is vastly superior and can report on data from the sql 2005 instance. If you are worried about the lack of a service pack for sql 2008 you can report on data in sql 2008 from reporting services 2005 (http://msdn.microsoft.com/en-us/library/ms143736.aspx)

If its local on your own pc you can have the development tools both installed at the same time (http://msdn.microsoft.com/en-us/library/bb500441.aspx); though in this case i would use the sql 2005 tools only if you are migrating to sql 2008 as SQL 2005 code works on 2008 but not necessarily the other way around.

If you have reporting services models make sure you check out report builder 2 which ms launched this week. Its a much better user experience than report builder 1.

u07ch
Hi, thanks for the reply, I will be looking into those links shortly. well actually this is for my dev box. For the billable projects I need SQL 2005 working properly and not suffer from any conflicts. SQL 2008 is for self learning. That's why I need them both together.
+3  A: 

I have a complete install of both SQL2005 developer and SQL2008 developer on my workstation. Nothing un-usual has happened. A collegue also has both installed and is making use of the BI side of SQL 2005, again we haven't noticed any ill affects. Server side I would think twice before installing both, but only becuase of resource usasge. If your box has sufficent resources available then I wouldn't expect any issue.

pipTheGeek