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 )

32 comments:

  1. wow, you really saved my time...

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

    ReplyDelete
  3. Moe,
    Thanks, I needed this long time ago.

    ReplyDelete
  4. 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
  5. Works perfectly Thanks so much

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

    ReplyDelete
  7. 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
  8. 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
  9. If you are facing same problem for SQL SERVER 2008, You better visit http://www.mssqltips.com/tip.asp?tip=1807

    ReplyDelete
  10. Thanks, you saved a lot of time.

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

    ReplyDelete
  12. 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
  13. 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
  14. 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
  15. Еще раз, Спасибо!!!!!

    ReplyDelete
    Replies
    1. рада найти вас здесь людей

      Delete
  16. Your a life saver!;-)

    ReplyDelete
  17. 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. 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
  18. nice, you really saved my time with this post.

    ReplyDelete
  19. how to connect sqlserver name

    ReplyDelete
  20. THANKS A LOT !!!! You really are a life saver !

    ReplyDelete
  21. Thanks you very much!

    ReplyDelete

All suggestions are welcome