How to install SQL Server Management Studio (SSMS)

Version 5

    Verified Product Versions

    Endpoint Manager 2016.xEndpoint Manager 2018.x

    LANDESK Management Suite (LDMS) and Ivant Endpoint Manager bundle MS SQL Server on a new installation. Should you need to connect and perform tasks on the database, you will need to use SQL Server Management Studio (SSMS). However, SSMS does not come as part of the installation bundle.

     

    To Download and install SSMS:

         1. Go to Download SQL Server Management Studio (SSMS) | Microsoft Docs

         2. Click the download button.

         3. Put a check in the box for "MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe" and click Next.

         4. Once your download has finished, Run the file.

         5. Select "New SQL Server stand-alone installation or add features to an existing installation".

              2014 ssms-1.png

         6. Select "Add features to an existing instance of SQL Server 2014". Then, click Next.

              2014 ssms-2.png

         7. Place a check in Management Tools - Basic. Then click Next.

               2014 ssms-3.png

         8. You will see something like the following progress par as it installs the tools.

              2014 ssms-4.png

         9. Finally, you will see the final screen. Then, click Close.

              2014 ssms-5.png

         10. SQL Server Management Studio is now installed. You will now be able to search for SSMS from the start menu and see the new icon.

              2014 ssms-6.png