Wednesday, January 2, 2008

How to install SQL Server BI Development Studio/SQL Server Management Studio

I was facing problem installing BI Development Studio/SQL Server Management Studio to my existing SQL Server 2005 installation. It was either throwig error saying "Your upgrade is blocked" or 'the components you have selected has already been installed".

The solution for this is, you need to uninstall the "Client Components' part from the exitsting SQL Server installation before you run the setup.exe. Here are the steps:

1. Open the Add/Remove Programs.
2. Select Microsoft SQl Server and click Remove
3. Select "Client Components" and let the wizard remove all the client componets from your system
4. Now run the SQL Server 2005 setup.exe file
5. After the initial 3 wizard screens, Select only "Client components". In advacned Tab make sure "Development tools" and BI Development Studio are selected
6. Click install.

Hope this would help those who are facing problem addig/installing SQL Server Development Studio/ BI Development Studio to an existing SQL Server installation.

1 comment:

Anonymous said...

This worked for me - it was 'workstation' rather than 'client' components in my case though.