-
Notifications
You must be signed in to change notification settings - Fork 2.9k
/
Copy pathsql-server-linux-faq.yml
173 lines (108 loc) · 13.6 KB
/
sql-server-linux-faq.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
### YamlMime:FAQ
metadata:
title: SQL Server on Linux FAQ
description: This article provides answers to frequently asked questions (FAQ) about SQL Server running on Linux.
author: rwestMSFT
ms.author: randolphwest
ms.date: 01/03/2024
ms.topic: conceptual
ms.service: sql
ms.subservice: linux
ms.custom: linux-related-content
title: SQL Server on Linux frequently asked questions (FAQ)
summary: |
[!INCLUDE [SQL Server - Linux](../includes/applies-to-version/sql-linux.md)]
The following sections provide common questions and answers for SQL Server running on Linux.
sections:
- name: Ignored
questions:
- question: General questions
answer: |
1. **What Linux platforms are supported?**
SQL Server is currently supported on Red Hat Enterprise Server, SUSE Linux Enterprise Server, and Ubuntu. It also supported running in a container with Docker. For the latest information about the supported versions, see [Supported platforms](sql-server-linux-setup.md#supportedplatforms).
1. **Will SQL Server on Linux work on other platforms**?
SQL Server is tested and supported on Linux for the previously listed distributions. Other Linux distributions are closely related and might be able to run SQL Server. If you choose to install SQL Server on an unsupported operating system, review the **Support policy** section of the [Technical support policy for Microsoft SQL Server](https://support.microsoft.com/help/4047326/) to understand the support implications. Also note that some community-maintained Linux distributions don't have a formal way to receive support if the underlying operating system is the problem.
1. **Is SQL Server on Linux the same as on Windows?**
The core Database Engine for SQL Server is the same on Linux as it is on Windows. However, some features are currently not supported on Linux. For a list of features that aren't supported on Linux, see the [Unsupported features & services](sql-server-linux-editions-and-components-2022.md#unsupported-features-and-services). Also review the [SQL Server on Linux: Known issues](sql-server-linux-known-issues.md). Unless specified in these lists, other SQL Server features and services are supported on Linux.
1. **What is the support policy for SQL Server?**
To understand the support policy, review the [Technical Support Policy for SQL Server](https://support.microsoft.com/help/4047326/support-policy-for-microsoft-sql-server).
1. **I am coming from a Windows SQL Server background. Are there resources to help learn how to use SQL Server on Linux?**
The [quickstarts](sql-server-linux-setup.md#platforms) provide step-by-step instructions on how to install SQL Server on Linux and run Transact-SQL queries. Other tutorials provide additional instructions on using SQL Server on Linux. For a third-party list of tips, see the [MSSQLTIPS list of SQL Server on Linux Tips](https://www.mssqltips.com/sql-server-tip-category/226/sql-server-on-linux/).
- question: Licensing
answer: |
1. **How does licensing work on Linux?**
SQL Server is licensed the same way for both Windows and Linux. In fact, you license SQL Server and then you can choose to use that license on the platform of your choice. For more information, see [How to license SQL Server](https://www.microsoft.com/sql-server/sql-server-2022-pricing), and [SQL Server Licensing Resources and Documents](https://www.microsoft.com/licensing/docs/view/SQL-Server).
1. **What edition of SQL Server should I choose when I already purchased it?**
When you run `mssql-conf setup`, you are presented with the following options:
```output
Choose an edition of SQL Server:
1. Evaluation (free, no production use rights, 180-day limit)
2. Developer (free, no production use rights)
3. Express (free)
4. Web (PAID)
5. Standard (PAID)
6. Enterprise (PAID)
7. Enterprise Core (PAID)
8. I bought a license through a retail sales channel and have a product key to enter.
```
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. 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 purchased Standard edition through a retail channel, select option 8. This option does prompt you to enter a key.
1. **How do I verify the installed version and edition of SQL Server on Linux?**
Connect to the SQL Server instance with a client tool such as **sqlcmd**, **mssql-cli**, or Visual Studio Code. Then run the following Transact-SQL query to verify the version and edition of SQL Server that you are running:
```sql
SELECT @@VERSION
SELECT SERVERPROPERTY('Edition');
```
- question: Installation
answer: |
1. **How do I get SQL Server installed on my Linux servers?**
Microsoft maintains package repositories for installing SQL Server and supports installation via native package managers such as yum, zypper, and apt. To quickly install, see one of the [quickstarts](sql-server-linux-setup.md#platforms).
1. **Can I install SQL Server on the Linux Subsystem for Windows 10 or Windows 11?**
No. Linux running on Windows 10 or Windows 11 is currently not a supported platform for SQL Server and related tools.
1. **Which Linux file systems can SQL Server use for data files?**
Currently SQL Server on Linux supports ext4 and XFS. Support for other file systems will be added as needed in the future.
1. **Can I download the installation packages to install SQL Server offline?**
Yes. For more information, see the package download links in the [Release notes](sql-server-linux-release-notes-2022.md). Also, review the [instructions for offline installations](sql-server-linux-setup.md#offline).
1. **Can I perform an unattended installation of SQL Server on Linux?**
Yes. For a discussion of unattended installation, see [Installation guidance for SQL Server on Linux](sql-server-linux-setup.md#unattended). See the sample scripts for [Red Hat](sample-unattended-install-redhat.md), [SUSE Linux Enterprise Server](sample-unattended-install-suse.md), and [Ubuntu](sample-unattended-install-ubuntu.md). You can also review [this sample script](/archive/blogs/sqlcat/unattended-install-and-configuration-for-sql-server-2017-on-linux) created by the SQL Server Customer Advisory Team.
- question: Tools
answer: |
1. **Can I use the SQL Server Management Studio client on Windows to access SQL Server on Linux?**
Yes, you can use all your existing tools that run on Windows to access SQL Server on Linux. These include tools from Microsoft such as SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), and OSS and third-party tools.
1. **Is there a tool like SSMS that runs on Linux?**
The new Azure Data Studio is a cross-platform tool for managing SQL Server. For more information, see [What is Azure Data Studio](../azure-data-studio/what-is-azure-data-studio.md).
1. **Are commands like sqlcmd and bcp available on Linux?**
Yes, [sqlcmd and bcp](sql-server-linux-setup-tools.md) are natively available on Linux, macOS, and Windows. In addition, use the new [mssql-scripter](https://github.com/Microsoft/mssql-scripter) command-line tool on Linux, macOS, or Windows to generate T-SQL scripts for your SQL database running anywhere. Also, see the preview release for [mssql-cli](https://blogs.technet.microsoft.com/dataplatforminsider/2017/12/12/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server/).
1. **Is it possible to view Activity Monitor when connected through SSMS on Windows for an instance running on Linux?**
Yes, you can use SSMS on Windows to connect remotely, and use tools/ features such as Activity Monitor commands on a Linux instance.
1. **What tools are available to monitor SQL Server performance on Linux?**
You can use [system dynamic management views (DMVs)](../relational-databases/system-dynamic-management-views/system-dynamic-management-views.md) to collect various types of information about SQL Server, including Linux process information. You can use [Query Store](../relational-databases/performance/monitoring-performance-by-using-the-query-store.md) to improve query performance. Other tools, such as the built-in [Performance Dashboard](/archive/blogs/sql_server_team/new-in-ssms-performance-dashboard-built-in), work remotely in SQL Server Management Studio (SSMS) from Windows.
> [!TIP]
> One way to improve performance is to properly configure your Linux operating system and the SQL Server instance. For more information, see [Performance best practices and configuration guidelines for SQL Server on Linux](sql-server-linux-performance-best-practices.md).
- question: Administration
answer: |
1. **Has Microsoft created an app like the SQL Server Configuration Manager on Linux?**
Yes, there is a configuration tool for SQL Server on Linux: [mssql-conf](sql-server-linux-configure-mssql-conf.md).
1. **Does SQL Server on Linux support multiple instances on the same host?**
No, we don't support multiple instances on the same host machine. If you need to run multiple instances on the same host, we recommend using multiple containers. Keep in mind that each container needs to listen on a different port. For more information, see [Run multiple SQL Server containers](sql-server-linux-docker-container-deployment.md#multiple).
1. **Is Active Directory Authentication supported on Linux?**
Yes. For more information, see [Active Directory Authentication with SQL Server on Linux](sql-server-linux-active-directory-authentication.md).
1. **Are Always On availability groups and clustering supported in Linux?**
Failover clustering and high availability on Linux are achieved with Pacemaker on Linux. For more information, see [Business continuity and database recovery - SQL Server on Linux](sql-server-linux-business-continuity-dr.md).
1. **Is it possible to configure replication from Linux to Windows and vice versa?**
Read-scale replicas can be used between Windows and Linux for one-way data replication.
1. **Is it possible to migrate existing databases in older versions of SQL Server from Windows to Linux?**
Yes, there are [several methods](sql-server-linux-migrate-overview.md) of achieving this.
1. **Can I migrate my data from Oracle and other database engines to SQL Server on Linux?**
Yes. SSMA supports migration from several types of database engines: Microsoft Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE). For an example of how to use SSMA, see [Migrate an Oracle schema to SQL Server on Linux with the SQL Server Migration Assistant](../ssma/oracle/sql-server-linux-convert-from-oracle.md?toc=/sql/toc/toc.json).
1. **What permissions are required for SQL Server files?**
All files in the `/var/opt/mssql` file folder should be owned by the `mssql` user and belong to the `mssql` group. Both the `mssql` user and group should have read-write permissions of all files and directories. Note the following special scenarios involving file and directory permissions:
* Permissions for `mssql` owner and group are required for mounted network shares that are used to store SQL Server files.
* If you locate database files or backups in a non-default directory, you must also set permissions for that directory.
* If you change the default root umask from `0022`, SQL Server configuration fails after installation. You must then manually apply required permissions to SQL Server startup account.
1. **Can I change the ownership of SQL Server files and directories from the installed `mssql` account and group?**
We don't support changing the ownership of SQL Server directory and files from the default installation. The `mssql` account and group are specifically used for SQL Server and has no interactive login access.
1. **Is Symbolic links supported for SQL Server data and log directories?**
No, symbolic links aren't supported for SQL Server data and log directories. To change the default data and log directories, see [Change the default data or log directory location](sql-server-linux-configure-mssql-conf.md#datadir).
1. **Can we remove the Builtin\Administrator account from SQL Server on Linux and containers instances?**
Dropping *Builtin\administrators* for SQL Server on Linux breaks execution of some of the system stored procedures. We suggest to not remove or drop the *Builtin\administrator* account from SQL Server on Linux/containers.
[!INCLUDE[Get Help Options](../includes/paragraph-content/get-help-options.md)]