If you install VSTS 2008 first successfully on your PC and then if you install SQL Server 2005 with default instance later, you might get the dialogue box saying that you can’t install SQL Server 2005 Tools (Workstation Components, Books Online and Development Tools) . If you try to install SQL Server 2005 tools with named instance, it is not working either. You may feel disappointed.
That’s because when you install VSTS 2008, you also install SQL Express automatically, which blocks you to install SQL Server 2005 tools.
Don’t worry. You can just do the following steps:
1. Go to Add/Remove Programs
2. Choose Microsoft SQL Server 2005.
3. Uninstall Workstation Components, Books Online and Development Tools.
4. Install SQL Server 2005 Tools again.
You will fix the problem.