Missing Sql Server Management Studio - solution

Missing Sql Server Management Studio - solution
The other day I was installing SQL Server 2005 and realized that the installation did not install Management Studio. So I reinstalled the sql tools from the CD but that didn't work so I uninstalled and reinstalled, still no luck. The only item which would show up under start-> programs-> Microsoft SQL Server is the Configuration Tools. If you are having the same issue you've come to the right place.

Problem:

SQL Server Management Studio did not install with sql server 2005

Issue:

When installing visual studio you may have installed SQLExpress, which created a tools folder in "C:\Program Files\Microsoft SQL Server\90". SQL Server installation will look for that folder and if it's found it will simply move on.

Solution: Rename the tools folder in C:\Program Files\Microsoft SQL Server\90 and then reinstall the tools and components off the CD.

This solution seems to be working for most people. Give Props to Koti for solving the problem.

KOTI: Recommends re-installing tools by gonig to set-up files and double clicking "SqlRun_Tools" exe file, then selected necessary tool to be installed. which worked like gem.

Hope this helps someone out.

Pete Orologas

Published Thursday, October 12, 2006 5:04 AM by Porologas
Comment Notification
If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments
Brent Arias said:
I think MS discovered this valuable solution of yours, and disabled it. I ran into the same problem (WinXP, Visual Studio 2005 Professional installed, then installed SQL Server 2005) of not having Management Studio. When I renamed the directory you mentioned, it just caused all kinds of problems with the installer (and the installer would just re-create the directory immediately anyway, sans studio).

But another trick worked. After I select the tools component for installation, using the tools installer executed directly from the CD, the next step says something like "the following items are already installed, and so are ignored" - it lists a documentation component as already installed, and shows a checkbox by it. It gives no explanation of what the check box is for. If you simply hit "next," you are told the installer has nothing to do (and you are doomed). But If you click the check box on the documentation item and hit next, it causes the tools to be uninstalled and re-installed with management studio. Problem solved.

What could possibly be more intuitive?


December 6, 2006 12:26 AM
Guli Polla said:
I have 64but version and neither of these options worked for me

Nothing happens if I change the name tools folder in either the 64bit or x86 paths

and the check box is not aviable as per the second solution!!!


December 13, 2006 5:48 AM
John Reynolds said:
I have a Visual Studio 2005 upgrade to VS '03. I had to reinstall Windows, and so directly installed VS without first installing the older version. Visual Studio installed, but I was never able to get SQL Svr management studio to install because it was "already installed". I finally clicked on "More Information" or some such, after which I found out that it's an upgrade and I have to install Sql Server 2000 first.

I'm beginning to hate the way Microsoft treats its paying customers.
February 7, 2007 2:31 PM
Lu Cao said:
I got same problem with SQL Server 2005.
I installed Visual Studio 2005 first, then install SQL SERVER 2005 64bit on Vista 64bit OS. but not install SQL Server Management Studio. tied to download form MS webstie. got error code "29506". tied uninstall SQL server 2005, not successed.
tied detele register on REGEDIT. reinstall SQL SERVER 2005 64bit. still not installed SSMS.

I dont know what can i do now. only way reload OS. but have to call MS actived OS and Microsoft 2007. so bad.
April 3, 2007 7:02 PM
koti said:
Hi, when i faced same issue, i tried to re-install tools by gonig to set-up files and double clicking "SqlRun_Tools" exe file, then selected necessary tool to be installed. which worked like gem.

Hope this helps you all.
April 27, 2007 8:54 AM
Matrix1000 said:
What koti said worked for me! Thanks!!!
April 29, 2007 10:31 PM
Carla said:
I did the suggestion from Koti and it worked!! Been fighting with this for days...thanks so much!
May 4, 2007 9:19 AM
Grant said:
Koti's suggestion worked perfectly for me! Unbelievable that this is such an issue...methinks Microsoft has some work to do on this one. Thanks Koti!
May 7, 2007 12:15 PM
Jim said:
On vista. i had VStudio 2005 and had the same problem after installing sql 2005 developer.

steps i did
1) remove sql server in control panel / programs (it will give you an option of express sql and sql 2005) - VS 2005 seems to install express sql without any option.
2) select and remove express 2005 with all the rubbish
3) run SqlRun_Tools from the cd .
4) follow thru the installation and it works
May 14, 2007 4:47 AM
Hoa said:
Thanks for the solution.
May 19, 2007 3:49 AM
Larry D said:
Having the same issue as Jim. His solution did the deed. Thanks Jim
June 5, 2007 8:54 PM
Gra said:
Thanks so much for the info guys, my head was wrecked!
I didnt need to rename the folder, simply ran the SqlRun_Tools exe
June 13, 2007 3:42 AM
John Reynolds said:
Thanks for this solution! Add me to the list of those who were having this problem. I needed Management Studio, and not the Express version, so I could more easily copy a database.

(I'm a different John Reynolds than the one who posted above. What are the odds?)
June 14, 2007 9:34 AM
Myron Bollman said:
I had this problem also, and simply ran the SqlRun_Tools and all is fixed! Thanks for the hints.
June 14, 2007 11:38 AM
elpres said:
the file is called sqlRun_tools.msi on my disc, the solution worked fine.. im soooo glaaad, i hvae been looking for studio mangement in a week.
June 15, 2007 3:50 AM
Mattisimo said:
I was installing the x64 version of SQL and didn't get the MS. Thank you so much for your help. I wish I had searched before assuming there was something wrong with windows and reinstalling my OS.

Looks like it puts a lot in the x86 fodler when it does it correctly.

Thanks again. *tips hat*
June 20, 2007 12:48 PM
Christian Donner said:
This did not work for me, unfortunately, and I am still investigating. I assume it is because I upgraded to SP1 after the install and Windows applied several patches. Anyways, I am getting this error:

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.
July 9, 2007 8:07 AM
Christian Donner said:
An update and a clarification: what did not work for me was the selective update of the client components. My distribution comes with a SqlRun_Tools.msi, not an exe. When I ran it I got the above error.
However, I was able to get the missing components by uninstalling the SQLExpress from the SQL Server setup (Control Panel, add/remove programs) - not the Visual Studio setup that originally installed. Once the Express edition was gone, I was able to re-run the SQL Server setup (the full version that auto-runs from the DVD) and install the missing pieces. I subsequently had to re-run the SP2 (not 1 as I misstated earlier) setup as well and it was only applied to the newly installed pieces.
July 9, 2007 9:26 AM
Jun said:
I got the same error with Christian Donner when I run the SqlRun_Tools.msi. But I don't want to uninstall the SQL server express edition since it is used for some vs2005 projects. Is there any solution without uninstalling SQL Express?

I have tried to rename the Tools folder and run SqlRun_Tools.msi again, not working either.
July 20, 2007 9:11 AM
Olen said:
My god, two computers, two installs. On the laptop, I had Sql 2005 express installed. So I uninstalled it. I uninstalled the mobile edition that was on there too. Then I found out that I needed to install IIS. Maybe I did, maybe not, but I installed. Then I had to run the install from the command line with an update parameter set because I still have other instances of SQL Server on the laptop. Finally, I got the tools to install. I think maybe I could have installed from the command line from the beginning and would not have had to go through all the trouble. I saw the management software. Now, since I'm on Vista, I then had to install service pack 2. It works now.

On my Desktop, I had already installed Sp2 when I realized I had an issue. So, I had to uninstall everything. It looks good now.

I've spent 3 hours with this. The install is very slow.
July 21, 2007 2:40 PM
Manny said:
already installed sp2 on standard and had sql express instance installed.
had to go to control panel and choose remove on SQL Server 2005. (was prepared to start again from scratch) Fortunately, there was an option to remove only workstation components. (the documentation was of a higher version number than what was on the DVD which was blocking the install) After that, using Koti's solution worked great!
July 27, 2007 11:12 AM
BIzz said:
File is called sqlRun_tools.msi on mine too the solution worked a treat, thanks Guys...
August 6, 2007 7:00 AM
vandba said:
Thanks for the solution! It works for me too.

Vandba
August 8, 2007 9:38 AM
KAULIK said:
Hi guys,
I am Having the same problem.
I have searched the whole PC & SQL Server 2005 DVD for the "SqlRun_Tools.msi" but couldnt found .
please help me .
thanx


August 11, 2007 3:00 AM
The Chad said:
Manny's solution worked a charm......sound....
August 13, 2007 7:05 AM
veron said:
hey am havin da same problem ......plis help me
September 5, 2007 7:55 AM
jospeh said:
Neither of the above two solutions works for me,why?
September 15, 2007 10:51 AM
Ryan said:
Worked like a charm!!! Saved me so much time. Microsoft has officially become the bain of my existance this week. Also remember to rename the Tools directory to something like 'Tools_bak'.

Cheers!
September 28, 2007 11:10 AM
Eugene said:
Thanks a lot! it work!
October 2, 2007 1:29 PM
Eugene said:
Thanks a lot! it works!
October 2, 2007 1:29 PM
Mank said:
I had problems with it on Vista.

The solution was to remove SQl Express and then remove the Workstation Components from SQl Server 2005.
October 3, 2007 9:42 AM
Elmar said:
Thanks Koti, saved me a lot of time!
Just ran $\Tools\Setup\SqlRun_Tools.msi and got my Management Tools installed from there.
October 9, 2007 1:05 AM
Chris Mosby’s IT Blog » Blog Archive » SQL Express 2005 Advanced Won’t Install Studio said:
PingBack from http://www.mosby.org/blog/2007/12/21/sql-express-2005-advanced-wont-install-studio-2/
December 22, 2007 6:13 AM
Chris Mosby’s IT Blog » Blog Archive » SQL Express 2005 Advanced Won’t Install Studio said:
PingBack from http://www.mosby.org/blog/2007/12/23/sql-express-2005-advanced-wont-install-studio-3/
December 23, 2007 6:31 PM
Rohit said:
I also got the same problem of Management studio not getting installed
January 7, 2008 8:53 PM
Huxley said:
Thanks allot guys, this worked for me. I used Manny's solution but when i was trying to open SqlRun_Tools.msi i got some errors. If you are facing this problem try this. After you have installed the sql server and downloaded the sp2. Go to programs in control panel, click remove Microsoft sql server 2005 and only chose the workstation components. After that start the sql install agen and then only install the workstation components. this worked for me, hope this helps someone.
January 10, 2008 4:23 AM
Pooya said:
Thanks Huxley.
Huxley's solution works!
January 20, 2008 1:54 AM
om said:
omg so annoying,

I tried the sqlRun_tools.msi and it ran but I got some cryptic error message when trying to open management studio. I then read somewhere else that you have to re-apply SP2. So, I went to Microsoft updated and re-applied SP2 and it now works!!!

This was on the 64x version
January 29, 2008 12:45 PM
Nathan Heberley said:
Thanks guys,

The solution that worked for me was to
1. uninstall Express and the workstation components.
2. Then run SqlRun_Tools.exe
3. reinstall workstation components

My issue is that I had some third party software that was using express and now I have to install them again.


Thanks for your help guys
January 30, 2008 3:15 PM
Brent Welke said:
I too had prolems not being able to install until I also installed "windows installer Cleanup Utility". Google it, install from Microsoft.

Like me you may find some extra installs of "SQL 2005 Express tools" installed on your machine that you are not seeing in the "Add Remove Programs". This utility will help you delete them so you can install then again.


January 31, 2008 4:41 PM
Fist said:
Ok neither of these stuff did not work and i wanted to keep SQL Express. Here is what you do:

1. Rename "Tools" directory
2. Go to Add/Remove Programs and click on "SQL Server 2005" - remove
3. Click on "Workstation Components" and remove them
4. When that is done click again on "SQL Server 2005" this time "Change"
5. At the top you will notice a blue link that gives you option to install additional stuff
6. Click that and it will prompt you for "Setup.exe" find it in second cd of SQL Server (tools cd)
7. Add all stuff
8. Install

All done :)

Hope it helped
February 3, 2008 8:40 AM
Gajendran said:
thanks a lot. its very useful to me
February 5, 2008 9:30 PM
Plavvy said:
i had the same problem using SBS2003. I ran the install from the command line with the switch -> SKUUPGRADE=1. This then allowed me to override the previous installation.
February 6, 2008 6:18 AM
dattard said:
The sqlrun_tools solution worked for me. Cheers.
March 4, 2008 12:11 AM
Chuck said:
Yet another satisfied customer. Thanks for the info.
March 6, 2008 5:26 AM
KayDsouza said:
Wow that was helpful! Worked like a charm.
March 6, 2008 10:03 PM
http://blogs.neudesic.com/blogs/pete_orologas/archive/2006/10/12/416.aspx said:
PingBack from http://frankthefrank.info/entry.php?id=kwws%3d22eorjv1qhxghvlf1frp2eorjv2shwhbrurorjdv2dufklyh2533924324527491dvs%7b
March 26, 2008 1:53 AM
Ross Hawkins said:
April 20, 2008 9:30 PM
FREE STUFF! SIGN UP FOR FREE! - Page 49 - Money in the Bank | Money Maker | Make Money Online said:
PingBack from http://www.themoneyinthebank.com/forums/referral-mlm-money-cyclers-network-marketing-discussion/7040-free-stuff-sign-up-free-49.html#post16634
May 6, 2008 8:48 PM
Sql Server 2005 Kurdum Management ? yok ? - Webmaster Forum & Webmaster Okulu said:
PingBack from http://www.r10.net/database/167585-sql-server-2005-kurdum-management-yok.html#post1818572
May 9, 2008 4:22 PM
sql server management studio said:
PingBack from http://alonzo.mediaplusnews.info/sqlservermanagementstudio.html
May 14, 2008 6:40 PM
CSIS blogs said:
Over the summer I went over various SQL server configurations that could work with/for our students in the labs (and also to be better informed when the inevitable questions would arise). I also wanted to be able to explore the wonderful new Integration
August 28, 2008 4:18 PM
CSIS Blogs said:
Over the summer I went over various SQL server configurations that could work with/for our students in the labs (and also to be better informed when the inevitable questions would arise). I also wanted to be able to explore the wonderful new Integrat
September 2, 2008 3:03 PM
Wayne Larimore - his Bloggin' Weighs said:
Missing SQL Server Management Studio
October 21, 2008 8:36 AM
instalacja MSSQL2005 developer edition na Vista Premium | hilpers said:
PingBack from http://www.hilpers.pl/54199-instalacja-mssql2005-developer-edition-na
January 18, 2009 7:23 AM