SQL Server Management Studio: Λήψη και εγκατάσταση MS SSMS
Φιόνα Μπράουν
⚡ Έξυπνη Σύνοψη
SQL Server Management Studio (SSMS) is Microsoft’s free graphical environment for connecting to, configuring, querying, and administering SQL Server. Downloading, installing, and launching SSMS gives access to the Object Explorer, Query Editor, and other core management windows.
Τι είναι το Server Management Studio;
SQL Server Management Studio (SSMS) is an integrated development environment (IDE) that provides a graphical interface for connecting to and working with Microsoft SQL Server. It was launched with Microsoft SQL Server 2005 and is used for configuring, managing, and administering all components within SQL Server, from the Database Engine to security and jobs.
Πώς να κατεβάσετε και να εγκαταστήσετε το SQL Server Management Studio
Ακολουθούν τα βήματα για λήψη και εγκατάσταση Microsoft SQL Server Management Studio (SSMS):
Σημείωση: Recent releases (SSMS 21 and SSMS 22) install through the Visual Studio Installer and download a stub named vs_SSMS.exe, so there is no standalone MSI. The classic SSMS-Setup-ENU.exe flow shown below still illustrates the core steps and field choices.
Βήμα 1) Ανοίξτε τον υπάλληλο Microsoft σελίδα λήψης.
Πηγαίνετε στο official SSMS download page on Microsoft Πρακτικές Πηγές and select the latest SQL Server Management Studio (SSMS) installer. The download page is shown below.
Βήμα 2) Double-click the downloaded file.
Once the download completes, you get an executable file (named SSMS-Setup-ENU.exe in older releases or vs_SSMS.exe in current ones). Double-click it to launch the installer, as shown below.
Βήμα 3) Κάντε κλικ στο κουμπί Εγκατάσταση.
The setup window appears. Click the εγκαταστήστε button to begin installing SQL Server Management Studio (SSMS) on your system, as shown below.
Βήμα 4) Wait until the installation process is done.
Installation begins. The screen below shows the Packages progress and the Overall progress bars.
Βήμα 5) Η ρύθμιση έχει γίνει.
Once the installation completes, SSMS Setup displays a screen with a “Setup Completed” message. You may be prompted to restart the computer.
How to access “Management Studio”
Now you are ready to open Management Studio. Go to Start Menu > Programs > Microsoft SQL Server Εργαλεία> Microsoft SQL Server Management Studio. The version number in the folder name matches the SSMS release you installed.
The Connect to Server screen appears, as shown below.
The Server Name defaults to the name selected while installing MS SQL Server. Let’s understand each of the fields:
- Τύπος διακομιστή: This selects one of the four available MS SQL services. We will work with the βάση δεδομένων Engine for creating and working with databases. Other server types include Analysis, Reporting, and Integration Services.
- Ονομα διακομιστή: This is the name of the server where MS SQL Server is installed and to which you need to connect. Generally, we use the server name as “Machine name\Instance,” where Instance is the name given to the SQL Server instance during installation of MS SQL Server.
- Αυθεντικοποίηση: This defaults to “Windows Authentication” if you used Windows Authentication during SQL Server installation. If you selected Mixed Mode (Windows και SQL Server Authentication) instead, you can also sign in with a SQL Server login.
- User name / Password: If an authentication method other than Windows Authentication (such as SQL Server Authentication) is selected, these two fields are required.
Πατήστε Connect. You are now connected to the SQL Server Management Studio environment.
Access “Management Studio” using the command line
Alternatively, you can open MS SQL Server Management Studio using the Windows command line. You need the full path of ssms.exe. Below is the default location and file name (the folder number matches your installed SSMS version):
Μονοπάτι:
C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE Exe name: ssms.exe
The command prompt with the full path entered is shown below.
The screenshot below shows the ssms.exe command ready to run.
Here are the steps to access SSMS via the command line:
- Άνοιγμα γραμμής εντολών από typing CMD in the search window.
- Type the entire path followed by ssms.exe as shown above and press Enter.
The Connect to Server screen then appears, the same way as described in the previous section.
Introduction to the Management Studio IDE
Below is the start screen for SQL Server Management Studio.
Ας συζητήσουμε κάθε ενότητα λεπτομερώς.
1) Εξερεύνηση αντικειμένων
The Object Explorer provides a tree view of the database objects contained in the server. This section shows all the Databases, Security, and Server Objects for quick reference. To view the components of each object, click the + icon located to the left of the object to expand it.
2) Databases selection dropdown
This dropdown allows the user to select the database in which the queries will run.
3) Επεξεργαστής ερωτημάτων
Here you can write all your queries. MS SQL Server provides interactive IntelliSense suggestions for tables, columns, and more for easy query creation.
4) Κουμπί εκτέλεσης
This button finally executes the query and returns the results.
Συμβουλές και ζητήματα SSMS
- Management Studio is a standalone product. It does not correspond to any specific version of SQL Server. Because SSMS is version-independent, one install (for example SSMS 21 or SSMS 22) can manage SQL Server 2016 through 2025 as well as Azure sql.
- Large scripts reduce readability, so use comments to improve it. Put “–” in front of any line to comment it out.
- Group comment: You can comment out a group of lines by selecting them all and clicking the icon shown in the image below.
An unexpected shutdown or system failure can cause data loss. Keep the AutoRecover option checked to minimize it. You can even customize the time interval for AutoRecover and the number of days the information is kept before it is deleted, under Tools > Options > Environment > AutoRecover.
In case of failure, a popup window appears with the recovered file name. You often need the result of a query to be saved in text format for future reference.
Click and select the highlighted icon above, then run any query. You are prompted to specify the location where the file is saved for future reference.
Εκδόσεις SSMS και ενημερώσεις
SSMS first shipped with SQL Server 2005 and remained bundled with SQL Server 2008, 2012, and 2016. In 2016, Microsoft made SSMS a free, standalone download and started numeric versioning at 16.x, followed by the 17.x and 18.x series.
Από τότε, Microsoft has released SSMS 19, SSMS 20, SSMS 21 (2025), and SSMS 22 (2025). SSMS 21 and later are rebuilt on Visual Studio 2022 with full 64-bit support, an optional dark theme, and Copilot integration (Preview). Microsoft supports only the latest release, so upgrading to the newest SSMS is recommended.
The complete version history is listed in the official SSMS release notes.
Λειτουργικά συστήματα που υποστηρίζονται SSMS
The table below maps SQL Server editions to their supported operating systems, where “Y” means supported and “N” means not supported. SSMS itself runs on Windows μόνο — Windows 11, Windows 10 (version 1607 or later), and Windows Server 2016 through 2025. To manage SQL Server from macOS or Linux, use Azure Data Studio instead.
