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.
Related Posts:
