Today, I reinstalled Windows XP on my computer. The installations of Visual Studio 2008 and SQL Server 2005 were done without any trouble, however when I saw that some tools like Management Studio and SQL Profiler has not been installed, I searched on the Internet about the reason of this problem and how to solve this. The problem and the solution is given below:
Problem: When you install Visual Studio 2008 before installing SQL Server 2005, even if SQL Server is installed on your computer as a server, the components coming with SQL Server do not installed.
Solution 1: First install SQL Server 2005 and then install Visual Studio 2008.
Solution 2: If you do the installation by following the opposite order given in solution 1; execute the setup.exe included in Tools directory in SQL Server installation CD by using the parameters given below in Command Prompt. Complete the update installation process in the installation window by choosing necessary components from the Client Components and Documentation, Samples and … choice.
The command that will be written in Command Prompt: start /wait setup.exe SKUUPGRADE=1
Necessary components will be installed to your computer.
PS: The installation is performed on Windows XP Professional operation system by using Visual Studio 2008 Team System Edition and SQL Server 2005 Developer Edition versions.