Sql-docs: What is the difference between User installer and System Installer?

[chanmmn]

What is the difference between User installer and System Installer? Can you explain it somewhere in the document?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 811ed1f4-1c78-aa1b-e752-307250ca8eb7
• Version Independent ID: f36629bf-b2e6-4993-7c77-32fa311ea942
• Content: Download and install - Azure Data Studio
• Content Source: docs/azure-data-studio/download.md
• Product: sql
• GitHub Login: @stevestein
• Microsoft Alias: sstein

[MightyPen]

@yualan HI Alan, the documentation article says a major difference between User vs System installers involves 'administrator privileges', but is there more we can say?:
_"User Installer (recommended)_
_The user installer is recommended because it does not require administrator privileges, which simplifies both installs and upgrades."._

For example, can we say that, after a User install, only that one user will have access to the installed tool? Is that a difference? What else can be say?

Thanks. GeneMi (SteveStein is on vacation).

[stevestein]

@chanmmn - Thanks for the suggestion. I updated the article with a little more info and link to the underlying Visual Studio Code explanation.

_The user installer is recommended because it does not require administrator privileges, which simplifies both installs and upgrades. The user installer does not require Administrator privileges as the location is under your user Local AppData (LOCALAPPDATA) folder. The user installer also provides a smoother background update experience. For more information, see User setup for Windows._

[MaDnKount-r]

Ok. So let me get this straight. Sure the user install is more efficient for the install and upgrades. But there's no guarantee I'd be the only user with access to the download. Where as the system install perhaps has some sort of parameters that I can set into place. Am I getting this right?

[WilliamAntonRohm]

@MaDnKount-r -- thank you for your question. Please consider these resources:

• DBA Stack Exchange
• Stack Overflow

@stevestein -- please look into this issue.

[WilliamAntonRohm]

@MaDnKount-r -- we are following up on this in your new Visual Studio issue MicrosoftDocs/visualstudio-docs/issues/5443.

[WilliamAntonRohm]

@MaDnKount-r -- thank you for your followup question. Apologies for the delay in responding.

@stevestein -- please look into this issue.

[stevestein]

@MaDnKount-r - Thanks for the feedback. I don't 100% understand the question. Can you clarify what the problem is you're encountering?

Thanks

[stevestein]

I'm going to go ahead and close this issue as there's nothing specific to add to the doc. Feel free to continue the conversation if needed.

Thanks!