SQL Server Management Studio missing

Question

i just installed sql server 2008 r2 and SQL Server Management Studio  After installation i found that the SQL Server Management Studio has not been installed   i wanted to install SQL Server Management Studio  but cannot find the installation for this  Any idea how to install it

User · Answer

Current version   SQL Server Management Studio  Direct link  http   go microsoft com fwlink  LinkID 828615  Version Information  This release of SSMS uses the Visual Studio 2015 Isolated shell  The release number  16 4 1 The build number for this release  13 0 15900 1 Supported SQL Server versions This version of SSMS works with all supported versions of SQL Server  SQL Server 2008 - SQL Server 2016   and provides the greatest level of support for working with the latest cloud features in Azure SQL Database  There is no explicit block for SQL Server 2000 or SQL Server 2005  but some features may not work properly  Additionally  one SSMS 16 x release or SSMS 2016 can be installed side by side with previous versions of SSMS 2014 and earlier     Older version of the answer for 2012  Installation steps    Download file  SQLEXPRWT x64 ENU exe  for your version aprox 1Gb Execute following command  note that installation need access to internet to download about 140Mb and you will need to interact with installer    Command  SQLEXPRWT x64 ENU exe  ACTION INSTALL  FEATURES TOOLS  QUIETSIMPLE  IAcceptSQLServerLicenseTerms  original answer was  https   dba stackexchange com questions 14438 how-to-install-sql-server-2008-r2-profiler Now posted  http   blog cpodesign com blog sql-2012-installing-sql-profiler

User · Answer

In SQL Server 2016 it has its own link     Just download it here  https   msdn microsoft com en-us library mt238290 aspx

User · Answer

Did you include  Management Tools  as a chosen option during setup     Ensure this option is selected  and SQL Server Management Studio will be installed on the machine

User · Answer

If you have a copy of backup of SQL Server setup then you could add features  Management Tools Basic Complete  as you requested   Please use the below steps in Windows machine    Go to Control Panel -  Programs -  Program and Features -  Select your current version of Microsoft SQL Server Right Click  select Change Uninstall Click Add features Select the backup copy folder Do the steps what you done for SQL Server installation until features selection Now select the features Management Tools Basic Complete or both And go ahead with process for complete installation  Now you should get  SQL Server Management Studio and you can browse your databases

User · Answer

I know this is an old question  but I ve just had the same frustrating issue for a couple of hours and wanted to share my solution  In my case the option  Managements Tools  wasn t available in the installation menu either  It wasn t just greyed out as disabled or already installed  but instead just missing  it wasn t anywhere on the menu   So what finally worked for me was to use the Web Platform Installer 4 0  and check this for installation  Products   Database     Sql Server 2008 R2 Management Objects   Once this is done  you can relaunch the installation and  Management Tools  will appear like previous answers stated   Note there could also be a  Sql Server 2012 Shared Management Objects   but I think this is for different purposes   Hope this saves someone the couple of hours I wasted into this

User · Answer

Try restarting your computer if you just installed SQL Server and there s no choice in the SQL Server Installation Center to install SQL Server Management Studio    This choice  see image below  only appeared for me after I installed SQL Server  then restarted my computer

[ssms] SQL Server Management Studio missing

Examples related to ssms