Then run the following Transact-SQL query to verify the version and edition of SQL Server that you are running: SELECT SERVERPROPERTY('Edition') How do I verify the installed version and edition of SQL Server on Linux?Ĭonnect to the SQL Server instance with a client tool such as sqlcmd, mssql-cli, or Visual Studio Code. This option does prompt you to enter a key. If you have purchased Standard edition through a retail channel, select option 8.
LINUX SQL SERVER CLIENT LICENSE
This step does not ask you to enter the license, but you must have previously purchased the appropriate license for your configuration. If you have obtained your license through volume licensing as part of an Enterprise Agreement or through your MSDN subscription, you need to select options 4 through 7. I bought a license through a retail sales channel and have a product key to enter. Developer (free, no production use rights)Ĩ. Evaluation (free, no production use rights, 180-day limit)Ģ. When you run mssql-conf setup you are presented with the following options: Choose an edition of SQL Server:ġ. What edition of SQL Server should I choose when I already purchased it?
LINUX SQL SERVER CLIENT HOW TO
For more information, see How to license SQL Server.
In fact, you license SQL Server and then you can choose to use that license on the platform of your choice. SQL Server is licensed the same way for both Windows and Linux. For a third-party list of tips, see the MSSQLTIPS list of SQL Server on Linux Tips. Other tutorials provide additional instructions on using SQL Server on Linux.
LINUX SQL SERVER CLIENT INSTALL
The quickstarts provide step-by-step instructions on how to install SQL Server on Linux and run Transact-SQL queries. Are there resources to help learn how to use SQL Server on Linux? I am coming from a Windows SQL Server background. To understand the support policy, review the Technical Support Policy for SQL Server.
What is the support policy for SQL Server? Unless specified in these lists, other SQL Server features and services are supported on Linux. For a list of features that are not supported on Linux, see the Unsupported features & services. However, some features are currently not supported on Linux. The core Database Engine for SQL Server is the same on Linux as it is on Windows. Is SQL Server on Linux the same as on Windows? Also note that some community-maintained Linux distributions do not have a formal way to receive support if the underlying operating system is the problem. But if you choose to install SQL Server on an unsupported operating system, please review the Support policy section of the Technical support policy for Microsoft SQL Server to understand the support implications. Other Linux distributions are closely related and might be able to run SQL Server (for example, CentOS is closely related to Red Hat Enterprise Server). SQL Server is tested and supported on Linux for the previously listed distributions. Will SQL Server on Linux work on other platforms? For the latest information about the supported versions, see Supported platforms. It also supported running in a container with Docker. SQL Server is currently supported on Red Hat Enterprise Server, SUSE Linux Enterprise Server, and Ubuntu.
0 kommentar(er)
