How to install SQL Server Management Studio for Personal Use

Luigi Vitale 0 Reputation points

Hello,

I would like to download the latest SQL Server Management Studio locally on my machine for personal use and training. I have been unemployed since Nov-2025 and I would like to maintain and increase my SQL skills. I would also like some basic training db's where I can load data and run queries.

Thank you,

Luigi Vitale

0 comments No comments
Sign in to comment

2 answers

  1. Erland Sommarskog 134.7K Reputation points • MVP • Volunteer Moderator

    To download SQL Server Management Studio go to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. You will download an installer stub, and then you can make choices of which optional components you want. You can add these components later if you wish.

    Note that with SSMS alone you will not get anywhere. You will also need SQL Server. You can download any of the Developer editions here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads. If you install SQL Server on your laptop, be sure to first take a look at this page: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size. It discusses a known issue which causes the installation of SQL Server to fail under some circumstances. You might as well check before you try installing. As for installing SQL Server, this download, too, is also a stub. You will get three choices: Basic, Custom and Download Media. I very much recommend the latter. If you would have the disk-sector issue that I mentioned when you run Setup you will get a warning. When you select Download Media, you get an ISO. Just double-click the ISO and run Setup.

    1. Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

      Hi @Luigi Vitale

      Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we'll assist further

      Thanks,

      Lakshmi

    Sign in to comment

  2. AI answer

    To install SQL Server Management Studio (SSMS) locally for personal use and practice, and to get sample databases, follow these steps.

    1. Install SQL Server Management Studio (latest version)
    2. Check system requirements to ensure the machine supports the latest SSMS version. See the system requirements for SSMS 21.0.0 or 22 as appropriate.
    3. Download the latest SSMS installer:
      • For SSMS 22, use Download SSMS 22: this downloads vs_SSMS.exe, a stub installer that opens Visual Studio Installer.
      • For SSMS 21, use Download SSMS 21 if specifically needing that version.
    4. Run vs_SSMS.exe (from the Downloads folder) as an administrator.
    5. When prompted by User Account Control, choose Yes, accept the Microsoft Privacy Statement and License Terms, and continue.
    6. Visual Studio Installer opens and shows SQL Server Management Studio as an available product.
    7. Optionally select additional workloads or individual components if needed, then select Install.
    8. Wait for the installation to complete. SSMS 22 can be installed side-by-side with other SSMS versions.

    If internet connectivity is unreliable, create an offline installation layout:

    1. Use the Download all, then install option in Visual Studio Installer (from the dropdown next to Install). This downloads all SSMS packages locally.
    2. After download completes, SSMS can be installed while offline using that local layout.
    3. Optional: Install SQL Server Database Engine for local practice

    SSMS is only a management tool. To practice creating databases, tables, and queries, install a SQL Server Database Engine instance locally (for example, SQL Server Developer or Express edition). After installation, connect from SSMS to the local instance and create practice databases.

    1. Get sample databases for training

    A common practice database is AdventureWorksDW2019:

    1. Download the AdventureWorksDW2019 backup from the GitHub release referenced in the tutorial.
    2. Copy the .bak file into the SQL Server backup directory on the local SQL Server instance.
    3. Start SSMS and connect to the Database Engine.
    4. Restore the AdventureWorksDW2019 database from the backup.

    This provides a realistic data warehouse schema for writing queries, building views, and practicing T‑SQL.

    For Analysis Services or multidimensional practice, follow the same tutorial to install developer tools and use the sample projects and databases.

    1. Keep SSMS updated
    2. To update SSMS 21 or 22, follow the update instructions in the SSMS install documentation.
    3. Updates are managed via Visual Studio Installer for SSMS 22.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.
Sign in to answer

Your answer