| title | Manage SQL Server on Linux | |
|---|---|---|
| description | This article provides links to common management tasks and tools for SQL Server running on Linux. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 07/11/2025 | |
| ms.service | sql | |
| ms.subservice | linux | |
| ms.topic | concept-article | |
| ms.custom |
|
|
| monikerRange | >=sql-server-linux-2017 || >=sql-server-2017 |
[!INCLUDE SQL Server - Linux]
There are several ways to manage [!INCLUDE ssnoversion-md] on Linux. The following section provides a quick overview of different management tools and techniques with pointers to more resources.
The mssql-conf tool configures [!INCLUDE ssnoversion-md] on Linux. For more information, see Configure SQL Server on Linux with the mssql-conf tool.
Almost everything you can do in a client tool can also be accomplished with Transact-SQL statements. [!INCLUDE ssnoversion-md] provides System dynamic management views that query the status and configuration of [!INCLUDE ssnoversion-md]. There are also Transact-SQL commands for database management tasks. You can run these commands in any client tool that supports connecting to [!INCLUDE ssnoversion-md] and running Transact-SQL queries, for example sqlcmd or Visual Studio Code.
Visual Studio Code is a cross-platform tool, and you can install the MSSQL extension to manage SQL Server. For more information, see What is the MSSQL extension for Visual Studio Code?
The Named Pipes protocol isn't supported for [!INCLUDE ssnoversion-md] on Linux.
SQL Server Management Studio (SSMS) is a Windows application that provides a graphical user interface for managing [!INCLUDE ssnoversion-md]. Although it currently runs only on Windows, you can use it to remotely connect to your Linux [!INCLUDE ssnoversion-md] instances. For more information on using SSMS to manage [!INCLUDE ssnoversion-md], see Use SQL Server Management Studio on Windows to manage SQL Server on Linux.
PowerShell provides a rich command-line environment to manage [!INCLUDE ssnoversion-md] on Linux. For more information, see Use PowerShell on Windows to manage SQL Server on Linux.