Installing SQL 2005 RTM and VS 2005 RTM
Over the last two days, I've been trying to install the latest releases of SQL Server 2005 and VS 2005 on my laptop. Earlier, I had them on a VPC and since the RTMs are out, I wanted to install them on the actual OS. SQL Server 2005 installed without a problem. However, when I installed VS 2005, it did finish successfully, but I started getting “Package Load Failures....” when opening any project. After some search on the internet, I came across this article: http://blogs.msdn.com/astebner/archive/2005/04/16/408856.aspx and also this one: http://blogs.msdn.com/astebner/archive/2005/04/19/409905.aspx. The symptoms explained in these posts were the exact ones that I'm facing (basically old Beta 2 bits lying around) and after going through the cleanup tool recommended in these articles, I got around 95% of the IDE working. The problem that I'm having are with the BI Studio components of SQL Server 2005. When I create a new Integration Services project, everything loads fine, but if I drag-and-drop some of the toolbox items like foreach containers etc, nothing happens on the design surface. However, other toolbox items like data flow, database backup etc are working fine. Not sure where the problem is.
Incidentally, I had to run the cleanup tool more than once and each time I run it, it still says that it has detected the Beta bits around. Thus, am not sure if I need to run it more times. Anyways, am almost there and should soon cleanup the other problems. For now, I'm happy with the revised performance that I'm getting by running the SQL Server 2005 and VS 2005 IDEs on my host machine :-) Also got back the 8GB that my earlier VPC had gobbled up!