Missing Microsoft SQL Management Studio after installation

If after you spend few hours install Microsoft SQL 2005 and found that Management Studio missing.

Don't panic, here's the solution!

1. Look for SqlRun_Tools.msi under your Setup folder CD2.

2. Select install "Client Components".


You're done.



However, you may received the following error message during the process.

"a component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component"

Then you need to do few more steps:

3. Go to Add/Remove Programs, select Microsoft SQL Server 2005 and Remove.

4. Check "Workstation Components" to remove and proceed.
P/S: Uncheck any other components!

5. After removal of "Workstation components", repeat Step 1 and 2 again to install Management Studio.