How to get mssql extention in ADS

Susja 711 Reputation points
2023-07-25T15:05:04.0333333+00:00

Hello,

I started to use ADS a few days ago.

Here are settings:

Version: 1.44.1 (system setup)

Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c

Date: 2023-06-01T02:12:48.765Z

VS Code: 1.70.0

Electron: 19.1.8

Chromium: 102.0.5005.167

Node.js: 16.14.2

V8: 10.2.154.15-electron.0

OS: Windows_NT x64 10.0.17763

I am mostly will use it for MS SQL related things .. like writing queries and etc.

Hence I wanted to install this extension :mssql

I looked in available list but I don't see it listed there.

What I'm doing wrong? Note: I don't have admin privileges for the server and it's controlled by my organization ..

Thanks

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
89 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 15,116 Reputation points Microsoft Employee
    2023-07-31T17:14:53.4533333+00:00

    Susja

    Azure Data Studio has the mssql extension essentially bundled into it (and that's what makes ADS a primary provider of mssql functionality).  You don't need to download it. It is already installed by default.

    You were not able to see it in ADS because it is not an extension for ADS, it is for VS code, to provide mssql functionality.

    VS Code and ADS are two different tools entirely.

    I am mostly will use it for MS SQL related things. like writing queries and etc.

    Hence, I wanted to install this extension :mssql

    You can do it in ADS.

    https://learn.microsoft.com/en-us/sql/azure-data-studio/quickstart-sql-database?view=sql-server-ver16

    https://learn.microsoft.com/en-us/sql/azure-data-studio/quickstart-sql-database?view=sql-server-ver16

    Regards,

    Oury

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Oury Ba-MSFT 15,116 Reputation points Microsoft Employee
    2023-07-25T16:27:58.9466667+00:00

    @Susja Thank you for reaching out.

    My understanding is that you are not able to install mssql extension in Azure Data Studio.
    Supported operating systems.

    The mssql extension for VS Code is supported on Windows, macOS, and Linux. The following versions are supported:

    • Windows: 7 (with SP1), 8, 8.1, 10, 11
    • Windows Server: 2016, 2019, 2022
    • macOS: 10.12+, 11, 12
    • Linux: Debian 9+, RHEL 7+, Ubuntu 18.04+

    review this mssql extension for Visual Studio Code

    I would suggest reviewing the doc info above which contains step by step and all the system requirement needed when install mssql extesion.

    Please comment below if that does not help. So, we can continue to work on the same.

    Regards,

    Oury