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
(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 )
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 )
wow, you really saved my time...
ReplyDeleteThanks buddy.You saved my time.
ReplyDeletethank you v.m., I'm does so sad because I think the world it's down, but your web resolve my problem
ReplyDelete:)
good
ReplyDeleteMoe,
ReplyDeleteThanks, I needed this long time ago.
Thanks so much!
ReplyDeleteunfortunetly i can't realy thank you
ReplyDeleteyou don't know how do great help to me!
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
Thanks a lot ..
ReplyDelete..
Works perfectly Thanks so much
ReplyDeleteMan,
ReplyDeleteIf only I could find you somewhere to buy you couple of beers!
Thank YOU! You are a great person.
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..."
ReplyDeleteI am at a loss ((
How do you do it for SQL 2008?
ReplyDeleteOnce again Microsoft have ****ed this up. I have struggled for hours trying to find it.
If you are facing same problem for SQL SERVER 2008, You better visit http://www.mssqltips.com/tip.asp?tip=1807
ReplyDeleteThanks, you saved a lot of time.
ReplyDeleteThanks! Been using SQL for awhile but never installed it myself..
ReplyDeleteLife 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.
ReplyDeleteThanks!
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.
ReplyDeletereally helpful!!!! thx!
ReplyDeleteThis is Microsoft... With Windows 2000 and XP I acceptet to work with Microsoft... seems these times are over...
ReplyDeleteI'm trying to make SQL Server 2008 and sql server management console etc. run for a day now...
Еще раз, Спасибо!!!!!
ReplyDeleteрада найти вас здесь людей
DeleteYour a life saver!;-)
ReplyDeleteThis is great thenks, could I please just confirm if there is any risk of losing existing DB's when changing the installed feature?
ReplyDeleteNO, 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.
DeleteThanks so much
ReplyDeletenice, you really saved my time with this post.
ReplyDeletenice one, Thanks
ReplyDeletehow to connect sqlserver name
ReplyDeleteKudos!
ReplyDeleteTHANKS A LOT !!!! You really are a life saver !
ReplyDeleteThanks you very much!
ReplyDeleteThanks!
ReplyDelete