Monday, July 20, 2009

How to install Sql Server Management Studio


How to install Sql Server Management Studio???Why I can’t install Sql Server Management Studio???
Unable to install Sql Server Management Studio???

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

Some time it becomes a mystery to install Sql Server Management Studio. Normally you click setup file to install Sql Server 2005 and its components, though you have selected Client Components (Which includes Sql Server Management Studio) to install with other components, but after installation is complete, you can’t find Sql Server Management Studio in installed programs list.
No need to uninstall and re-install your whole Sql Server 2005. Leave the installed components as is and find out SqlRun_Tools setup file to execute, from following path.

 Click Change Installed Components ...



Click on CLIENT COMPONENTS, install it completly or you can just select Management Tools. What ever you select DON'T forget to select "Entire feature will be installed on local hard drive"


Click Next button and let it install and here is Sql Server Management Studio…….
Enjoy.... ;)



Installing Only SQL Server Management Studio

If you are interested to install SQL Server Management Studio for Express Edition then following video at youtube will be helpful for you

How to install SQL Server 2008 Management Studio Express



(And If you are looking for only client tools (Sql Server Management Studio 2008) installation in Sql Server 2008. You must visit http://www.mssqltips.com/tip.asp?tip=1807 )
at 5:50 PM
Labels: ,

32 comments:

  1. AnonymousSeptember 15, 2009 at 9:34 AM

    wow, you really saved my time...

    ReplyDelete
  2. JaynishNovember 17, 2009 at 9:03 AM

    Thanks buddy.You saved my time.

    ReplyDelete
  3. Cota-CotaDecember 10, 2009 at 1:16 AM

    thank you v.m., I'm does so sad because I think the world it's down, but your web resolve my problem
    :)

    ReplyDelete
  4. AnonymousJanuary 25, 2010 at 9:21 PM

    good

    ReplyDelete
  5. AnonymousMarch 9, 2010 at 9:33 PM

    Moe,
    Thanks, I needed this long time ago.

    ReplyDelete
  6. AnonymousMarch 29, 2010 at 10:09 AM

    Thanks so much!

    ReplyDelete
  7. AnonymousApril 19, 2010 at 6:21 AM

    unfortunetly i can't realy thank you
    you don't know how do great help to me!
    Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks

    ReplyDelete
  8. HemantApril 26, 2010 at 12:16 PM

    Thanks a lot ..

    ..

    ReplyDelete
  9. AnonymousMay 5, 2010 at 3:05 PM

    Works perfectly Thanks so much

    ReplyDelete
  10. AnonymousMay 23, 2010 at 9:02 PM

    Man,
    If only I could find you somewhere to buy you couple of beers!
    Thank YOU! You are a great person.

    ReplyDelete
  11. AnonymousSeptember 29, 2010 at 6:21 PM

    I get the same messages when I reinstalling whole MSSQL SERVER 2005. It says that "A component that you have specified in the ADD_LOCAL property is already installed..."
    I am at a loss ((

    ReplyDelete
  12. AnonymousNovember 30, 2010 at 7:58 PM

    How do you do it for SQL 2008?
    Once again Microsoft have ****ed this up. I have struggled for hours trying to find it.

    ReplyDelete
  13. aasim abdullahDecember 4, 2010 at 6:04 PM

    If you are facing same problem for SQL SERVER 2008, You better visit http://www.mssqltips.com/tip.asp?tip=1807

    ReplyDelete
  14. AnonymousJanuary 5, 2011 at 7:47 PM

    Thanks, you saved a lot of time.

    ReplyDelete
  15. AnonymousJanuary 20, 2011 at 11:25 PM

    Thanks! Been using SQL for awhile but never installed it myself..

    ReplyDelete
  16. AnonymousFebruary 7, 2011 at 11:48 PM

    Life saver... I was so confused that SQL Server Management Studio wasn't installed! The only thing I really NEEDED was SSMS, but after the install I couldn't find it anywhere.

    Thanks!

    ReplyDelete
  17. AnonymousMay 10, 2011 at 7:48 PM

    thanx a million times.ur advice had been a great help.i have been trying to install sql server 2005 for 2 weeks but failed.i followed ur instructions & it worked.thanks once again.

    ReplyDelete
  18. jamieJuly 15, 2011 at 9:29 AM

    really helpful!!!! thx!

    ReplyDelete
  19. AnonymousNovember 17, 2011 at 5:00 PM

    This is Microsoft... With Windows 2000 and XP I acceptet to work with Microsoft... seems these times are over...
    I'm trying to make SQL Server 2008 and sql server management console etc. run for a day now...

    ReplyDelete
  20. AnonymousJune 6, 2012 at 10:58 AM

    Еще раз, Спасибо!!!!!

    ReplyDelete
    Replies
    1. aasim abdullahJune 6, 2012 at 5:50 PM

      рада найти вас здесь людей

      Delete
  21. AnonymousDecember 14, 2012 at 7:00 AM

    Your a life saver!;-)

    ReplyDelete
  22. AnonymousJanuary 18, 2013 at 10:03 AM

    This is great thenks, could I please just confirm if there is any risk of losing existing DB's when changing the installed feature?

    ReplyDelete
    Replies
    1. aasim abdullahJanuary 19, 2013 at 5:56 PM

      NO, not at all. But you must take regular backups of your production databases before any major change. But, for installing Client Components (SSMS etc.) will never effect your databases.

      Delete
  23. AnonymousMarch 5, 2013 at 5:37 AM

    Thanks so much

    ReplyDelete
  24. AnonymousMarch 5, 2013 at 10:20 AM

    nice, you really saved my time with this post.

    ReplyDelete
  25. AnonymousAugust 17, 2013 at 11:27 AM

    nice one, Thanks

    ReplyDelete
  26. AnonymousAugust 23, 2013 at 3:41 AM

    how to connect sqlserver name

    ReplyDelete
  27. AnonymousDecember 4, 2014 at 10:40 AM

    Kudos!

    ReplyDelete
  28. AnonymousMay 6, 2015 at 9:57 AM

    THANKS A LOT !!!! You really are a life saver !

    ReplyDelete
  29. AnonymousAugust 12, 2015 at 5:46 PM

    Thanks you very much!

    ReplyDelete
  30. Reading HallSeptember 1, 2015 at 12:04 PM

    Thanks!

    ReplyDelete

All suggestions are welcome

Subscribe to: Post Comments (Atom)