Menu
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?
364
How to access “Management Studio.” Now, we're ready to open “Management Studio. Go To Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft SSMS 18. Below 'Connect to Server' screen will appear.
To start SQL Server Management Studio On current versions of Windows, on the Start page, type SSMS, and then select Microsoft SQL Server Management Studio. When using older versions of Windows, on the Start menu, point to All Programs, point to Microsoft SQL Server, and then select SQL Server Management Studio.
Install SQL Server Management Studio (SSMS) Click on the link to download the latest SQL Server Management Studio (SSMS) link, as shown below. Once the download is complete, go to the download folder in your system. Find the SSMS-Setup-ENU.exe and double click to install SSMS.
Go to all programs in your systems, we can see two folders one is Microsoft SQL Server 2019 and another one is Microsoft SQL Server Tool 2018. Under Microsoft SQL Server Tools 18 you can see the Microsoft SQL Server Management Studio 18.
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.
135
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.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
