Hướng dẫn cài sql 2023 management studio năm 2024
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Show Download SQL Server Management Studio (SSMS)
In this articleApplies to: SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts. Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer or in the cloud. For customers needing a cross-platform companion to SSMS for managing SQL and other Azure databases, use Azure Data Studio. Download SSMSFree Download for SQL Server Management Studio (SSMS) 19.3 SSMS 19.3 is the latest general availability (GA) version. If you have a preview version of SSMS 19 installed, uninstall it before installing SSMS 19.3. If you have SSMS 19.x installed, installing SSMS 19.3 upgrades it to 19.3.
By using SQL Server Management Studio, you agree to its license terms and privacy statement. If you have comments or suggestions or want to report issues, the best way to contact the SSMS team is at SQL user feedback. The SSMS 19.x installation doesn't upgrade or replace SSMS versions 18.x or earlier. SSMS 19.x installs alongside previous versions, so both versions are available. However, if you have an earlier preview version of SSMS 19 installed, uninstall it before installing SSMS 19.3. You can see if you have a preview version by going to the Help > About window. If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs. The latest version is labeled Microsoft SQL Server Management Studio v19.3. Important Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid. To learn more about Azure Data Studio, check out What is Azure Data Studio or the FAQ. Available languagesThis release of SSMS can be installed in the following languages: SQL Server Management Studio 19.3: Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish Tip If you access this page from a non-English language version and want to see the most up-to-date content, please select Read in English at the top of this page. You can download different languages from the US-English version site by selecting . What's newFor details and more information about what's new in this release, see Release notes for SQL Server Management Studio (SSMS). Previous versionsThis article is for the latest version of SSMS only. To download previous versions of SSMS, visit . Note In December 2021, releases of SSMS prior to 18.6 will no longer authenticate to Database Engines through Microsoft Entra multifactor authentication (MFA). To continue utilizing MFA, you need SSMS 18.6 or later. Connectivity to Azure Analysis Services through Microsoft Entra multifactor authentication requires SSMS 18.5.1 or later. Unattended installYou can install SSMS using PowerShell. Follow these steps to install SSMS in the background with no GUI prompts.
Installation with Azure Data Studio
UninstallSSMS might install shared components if it determines they're missing during SSMS installation. SSMS doesn't automatically uninstall these components when you uninstall SSMS. The shared components are:
These components aren't uninstalled because they can be shared with other products. If uninstalled, you might run the risk of disabling other products. Supported SQL offerings
SSMS system requirementsThe current release of SSMS supports the following 64-bit platforms when used with the latest available service pack: Supported operating systems:
1 SSMS requires .NET Framework 4.7.2. Supported hardware:
Note SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Visit Azure Data Studio, for more details.
Related content
Contribute to SQL documentationDid you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page. |