Thursday, August 21, 2008

SQL Server Management Studio missing after installing SQL Server 2005 on Window Vista

Sometimes this could happen when you install or reinstall SQL Server on Window Vista. I am not very sure what is the cause of it but it took away 1-3 days to figure out what was wrong with all these. It will be even worst when you find your Business Intelligence Development Studio missing as well.

Ok, do not worry about it.

What you need to do is

  1. Do not uninstall it.
  2. Go to your Microsoft SQL Server folder -> 90 -> Tools. And rename the Tools folder name to Tools-Bak
  3. Insert your SQL Server DVD and Browse it.
  4. Find a folder named Tools and execute the installer in the folder. It will basically install the missing tools (Management Studio, etc) and Sample Database.
  5. if you have problem with the SQL Server instance attaching the sample databases, do not install it else it will bring more headaches to you.
  6. Once you have finished installing the tools.. you will find a new Tools folder appear in your Microsoft SQL Server -> 90 folder.
  7. Now it should solve your headaches. Do not think it is finished, Apply Service Pack 2.

Hope It helps.

1 comment:

Anonymous said...

Thanks for the post save me a third re-install procedure