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 for business Windows Server User experience Other
SQL Server Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    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 41,491 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.