Reputation: 13708

SQL Server Management Studio

Is it possible to install Management Studio by itself, and if so, is there a separate download/install exe for it?

Upvotes: 5

Answers (8)

Bassel Al Halabi

Reputation: 1

use below link in order to download SQL Server Management Studio https://download.microsoft.com/download/7/7/3/7738e337-ed99-40ea-b8ae-f639162c83c3/SSMS-Setup-ENU.exe

after downloading the exe file follow the steps

Upvotes: 0

Nick M

Reputation: 21

I believe that if you install SQL Server Management Express, you can't manage all the objects you can in the version you get from installing from the media. For example, you can't manage integration services or analysis services with management express.

The only way I've ever been able to install it is from the media; but like a previous post mentions, you don't have to install the database engine.

It's confusing for new DBAs that's for sure. I spent a significant amount of time trying to find a "SSMS.msi" on microsoft's website before I figured out it was on the media, and could be installed without installing the database engine; though you have to go to "install SQL Server Stand-alone" to get to it.

Fortunately, I'm still having a hard time trying to keep the server version and all the developers that need SSMS on the same version. If anyone knows of a way to make an .MSI (or download) one that contains all the correct versions of A.S./S.S.I.S/Database Engine I would love to hear it.

Upvotes: 2