Make ADS An Optional Install Alongside SSMS
Starting with SSMS 18.7, Azure Data Studio is being automatically installed alongside SSMS with no option to not install it. ADS is still available as a standalone install, though.
I'd like a way to make the install optional for people who don't need any ADS functionality.
Particularly for admins putting SSMS on their SQL Server for whom additional unknown dependencies might not be tolerable to security teams, not having to remember to uninstall additional items every time they update SSMS would be helpful. Even with an automated deployment, it requires an installation and then multiple uninstaller runs.
On top of that, ADS is updated monthly, and SSMS has a less frequent release cadence. That leaves most people juggling two installers anyway, or only updating ADS when they update SSMS. That seems an odd choice, especially given the lack of reciprocal bundling.
From Apr 24, 2019 (https://cloudblogs.microsoft.com/sqlserver/2019/04/24/sql-server-management-studio-ssms-18-0-released-for-general-availability/):
Think of these two tools not as separate tools doing different things, but as one integrated tool. Each tool has different experiences built into it and can be launched from the other seamlessly.
From Oct 20,2020 (https://cloudblogs.microsoft.com/sqlserver/2020/10/20/sql-server-management-studio-18-7-now-generally-available/):
SQL Server Management Studio is a foundational tool for many working with Microsoft data solutions. First released in 2018, Azure Data Studio is a cross-platform and open source desktop environment for data professionals using the Azure Data family of on-premises and cloud data platform solutions. Architecturally, SQL Server Management Studio has long been combined with additional tools, including Profiler, Database Engine Tuning Advisor (DTA), and Database Mail. As Azure Data Studio continues to mature, the Microsoft data tools experience on Windows has become a combination of SSMS and Azure Data Studio. Beginning in the 18.7 release of SQL Server Management Studio, Azure Data Studio is installed alongside SSMS automatically. Users of SQL Server Management Studio will be able to benefit from the innovations in Azure Data Studio, whether their environments are cloud, on-premises, or hybrid.
Please stop adding Azure DataStudio **** to a good product. This add-on is not nearly in half usable as SQL Server Management Studio and always needs to be removed.
I appreciate the work that goes into SSMS, and will continue using that.
But every time I use ADS, I run into basic breaking bugs. I've tried for years - it's still not production-ready.
Again, thanks for the continuing work on SSMS. Much appreciated!
Stop pushing Azure Data Tools with SSMS - when we download SSMS we usually know exactly what we want, and it's not the ludicrously expensive Azure.
no, we really want these to be separate. we already use azure data studio for certain things, and have team configuration and everything else already managed and set up.
the last thing we need is a separate installer possibly overwriting and messing up our environments.
they are, in fact, two separate, though related tools.
one is not required for the other. please remove azure data studio from the ssms installer.
I really wish we could downvote the product manager for this. If they're going to be an "integrated tool", make them one product, not two. Given how poor a product ADS is (see other comments for details of fundamental unfixed product flaws) this doesn't make sense. Leverage an existing, stable product and improve it. Creating ADS as a separate product was a poor decision that they appear to be justifying not by improving the product, or merging it with SQL Server Management Studio, but by simply ignoring user comments and claiming benefits for the product that it can't live up to.
It seems to me that Microsoft no longer cares about its customers.
Pascal Deliot commented
I do not want Azure Data Studio on my SQL Server management machine.
How to prevent Azure Data Studio Installation when update SSMS?
Fabian Lopez commented
Add option for enable or disable the installation of Azure Data Studio
Ian Kemp commented
Azure Data Studio is incredible garbage that can't even get basic features like logins to work correctly (see https://github.com/microsoft/azuredatastudio/issues/8331 which was filed over a year ago and remains unfixed). Yet Microsoft sees fit to foist this obviously alpha (no, not even beta) product on us.
Get it straight Microsoft - nobody wants ADS because nobody wants a product that is obviously inferior to the one it's supposedly "replacing". Stop trying to force us to be your alpha testers for a product that is neither wanted nor needed.
The hero we need...
I finally stumbled upon the correct command line call:
Note that you STILL get the dialog that states that Azure Data Studio WILL be installed!!
Microsoft, please fix that. And also update the SSMS 18.8 notes to explicitly state how to not install ADS. Thanks in advance.
So in my attempt to get rid of SSMS 18.8's failed installation, I used the command line call the exe tells me to use to uninstall, namely:
SURPRISE!! It gives the attached dialog, and does INDEED proceed to yet another failed installation (as per my last post).
Late to the party, but this is utterly egregious!!!
I see now that there is an option in 18.8 to use a flag to prevent ADS installation:
At this time, the installation of Azure Data Studio can be skipped by launching the SSMS installer with the command line flag DoNotInstallAzureDataStudio=1.
What is not mentioned, is which of the numerous ways of sending a "flag" into an executable are to be used? Uncertain, I tried this:
To which I received a popup as attached. This lead me to assume I should use this for the installation to NOT install ADS:
Since I wasn't certain that would work, I followed along, and sure enough making a ton of disk writes as part of the SSMS installation here came ADS down my throat!! I cancelled and it rolled back without error.
Next I tried this:
FAIL, as I noticed this time the the initial installation dialog actually stated "Microsoft SQL Server management Studio with Azure Data Studio"
Then the installation errored out, before I could cancel it, with attached dialog. The log error was this:
5C80:03D8][2021-02-11T12:00:58]e000: BootstrapperEngineDataModel.OnError: Burn engine encountered error. PackageId: sql_ssms_x64, ErrorType: WindowsInstaller, ErrorCode: 1303, Data: 1303,D:\Program Files (x86)\SSMS18\Common7\IDE\SqlWorkbenchProjects, ErrorMessage: The installer has insufficient privileges to access this directory: D:\Program Files (x86)\SSMS18\Common7\IDE\SqlWorkbenchProjects. The installation cannot continue. Log on as administrator or contact your system administrator., UIHint: 5
[5C80:03D8][2021-02-11T12:00:58]i000: MainViewModel.AddFailedCondition: Error: SQL Server Management Studio: The installer has insufficient privileges to access this directory: D:\Program Files (x86)\SSMS18\Common7\IDE\SqlWorkbenchProjects. The installation cannot continue. Log on as administrator or contact your system administrator.
[5C80:03D8][2021-02-11T12:00:58]e000: MainViewModel.OnPackageError: setup failed for packageId: sql_ssms_x64, package: SQL Server Management Studio, errorCode: 1303, errorMessage: The installer has insufficient privileges to access this directory: D:\Program Files (x86)\SSMS18\Common7\IDE\SqlWorkbenchProjects. The installation cannot continue. Log on as administrator or contact your system administrator.
My original SSMS installation is now non-functional.
and everything played out the same as with single dash.
So now I get to somehow try to salvage an operational SSMS copy of my prior version, clean up the **** that is left from the apparently failed rollback of the ADS install, and I STILL have NO IDEA how to install SSMS WITHOUT ADS using the proffered command line flag.
Jake O'Neill commented
It shouldn't be installed in the first place unless the user asks for it. I know Microsoft are aggressively pushing their cloud based platform but removing the choice is a new low and the dismissive response above will only create hesitation and pushback against MS. The product should speak for itself, if it's great we'll install it, till then it's bloatware.
This is in a agreement with our sql team in London.
Jason Baginski commented
I have to agree to the terms and conditions of Azure Data Studio in order to install SQL Management Studio?
Greg Wojan commented
Just... Wow! I can't even... :( I just installed SSMS 18.7.1 on a new laptop that already had a user installation of Azure Data Studio present and the SSMS installer dropped a system install of Azure Data Studio! Not cool Microsoft! This is not cool at all!
What a terrible user experience! From the Start Menu only the user install is visible. From the command line the system install is first in the PATH. :( Not only that, the system install was added to both the user PATH and system PATH. I'm already having issues with really long PATH variables so this is TERRIBLE!
Please, I implore you, make ADS an optional install or better yet don't bundle it with SSMS. #MajorFAIL
This is a very bad idea to add more to the installation of SSMS
There is a legitimate reason to have it installed on some database servers for administrative purposes but as a general rule we try to limit installed software on servers to minimize patching needs. There have been issues where servers with ssms installed have needed to be patched because of security errata in the software needed for SSMS (XML Parser for instance) and adding ADS as nice as it is to the servers just opens up a new can of security related worms. Now we have typescript runtimes, automatically installed python runtimes and a whole new can of worms to monitor.
Please revisit this.
Joel Miller commented
Agreed. I have also had my organization stop all automated upgrades. We usually keep completely current within a few days of GA. Each piece of software is supposed to reviewed, approved, and deployed to everyone. Some people will want/need SSMS. Some will want/need ADS. Some users will have both. There are times where we need to install the newest SSMS because of a feature but we will NOT approve the newest version of ADS as there might be a bug or other issue (sometimes even on our side). These items should not be tied together. Either merge them completely or separate them. At least give us the option to select not to install ADS with a switch.
Hugo Kornelis commented
Is this response from a product manager for real? Are we back in the '90s of software companies shoving their favorite add-ons through their cutomer's tools?
I get that you want people to use the shiny new toy. This is not the way. This actually brings out the adolescent in me: it makes me even LESS likely to want to use ADS.
You want people to use ADS? Simple solution: make it better!
Kurt Moskal commented
This is a bad move. If I want Azure Data Studio I'll install Azure Data Studio. Please remove it or at least give option to not install it.
You can automate it by just runing the Uninstall quietly afterwards, stupid, but the only way to get it of the Server that has no internet connection anyway...
UninstallString "C:\Program Files\Azure Data Studio\unins000.exe"
QuietUninstallString "C:\Program Files\Azure Data Studio\unins000.exe" /SILENT