Install SQL Management Studio without Visual Studio Tools or Shell

TheLoops 6 Reputation points
2023-11-24T14:04:03.66+00:00

Hi there, I am doing some pen test remediation and our SQL servers are flagging that Visual Studio tools such as Shell (isolated) and Tools for applications are vulnerable.

So i've been trying to find a way to install SSMS without Visual Studio at all as we don't need the development aspects.

I've downloaded the SMSS 19.2 exe and have run the switch to not install Azure Data Studio but i'm keen to not include Visual studio if possible. Any advice appreciated!

Many thanks,

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,434 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,344 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 106.8K Reputation points
    2023-11-24T15:45:11.43+00:00

    SSMS is based on the Visual Studio shell, and this is a core component, nothing which is optional. You cannot install SSMS without bringing the VS Shell, just like you cannot run a computer without a CPU.

    If you want to avoid the VS shell, Azure Data Studio is your best option. (And it can be downloaded separately from SSMS.)

    0 comments No comments

  2. ZoeHui-MSFT 35,546 Reputation points
    2023-11-27T05:55:15.68+00:00

    Hi @TheLoops,

    SSMS is based off the Visual Studio Isolated Shell.

    You could not install it without VS.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments