SQL Server Management Studio did not install with sql server 2005.
It is supposed to be located at ‘C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\’ folder and the name is ‘SqlWb.exe’. There should also be a shortcut located at ‘Start – Programs – Microsoft SQL Server 2005′ folder.
So by doing some research, I came across many different solutions, and some of them guided me in the correct direction. Apparently, this can happen when you have missed to install certain components, or if you have installed SQL Express, or Visual Studio (which comes with SQL Express), and during the installation, the installation program recognizes the ‘tools’ folder at ‘C:\Program Files\Microsoft SQL Server\90\’.
So what should you do?
Well, I solved it by renaming the ‘tools’ folder to something like ‘toolsbak’
Then I went to ‘Add/Remove Programs’ which is located in the Control Panel folder. I located the Microsoft SQL 2005, clicked it and two buttons appear. One is the ‘Change’ button and the other is ‘Remove’ button, of which I clicked on the ‘Change’ button.
This opens a new window, where I selected the ‘Workstation Components’ radio button. The program at this point does some checks on your system, and then you get to a screen where you can select the button ‘Change Installed Components’. Next you have to expand (press the + sign next to the) Client Components, right clicking on the ‘Management Tools’ will bring up a window where you select ‘Will be installed on local hard drive’.
That’s it.
Incoming search terms for the article:
sql missing management tools, SQL Server Management Studio missing, download adventureworksdw2008, AdventureWorks sdf download, sql management studio missing visual studio, sql server for management program, sql server icon missing, sql server management studio disapeared, sql server management studio icons missed, sql server management studio is missing, sql server management tool missing, sql server manager for android, tool files in 90 folder are missing, vsshell folder is missing in sql server 2005, where\s sql server management studio missing, sql management studio missed, sql management studio icon gone, sql management studio disappeared from program, AdventureWorksDW2008 mdf, icon missing sql server management, microsoft missing sql server management studio, microsoft sql server management for android, Microsoft SQL Server Management Studio 2005 ???????, missing IDE folder mssql, missing MS SQL Server Management Studio, missing sql server management studio, missing sqlserveragent management studio, program files\Microsoft Sql server\90\tools\binn\vsshell folder is missing, service specific error code 3417 in ms sql server 2005, service-specific error code 3417, sql management studio c:\program files\, windows not start sql server express error code 3417
