Microsoft SQL Server
For the proper functioning of the system PANTHEON the use of a supported version of Microsoft SQL Server is required.
The instruction covers requirements and recommendations for the use of Microsoft SQL Server with the PANTHEON system. It includes an overview of supported versions with differences between free and paid editions, warnings regarding the use of outdated versions, and instructions for installation, upgrade, and management of the SQL server.
The minimum supported version is: Microsoft SQL Server 2017
Recommended version for new implementations: Microsoft SQL Server 2022
Unsupported versions: Microsoft SQL Server 2016 and older
Table of supported versions:
| Version |
Express |
Standard, Enterprise |
Version status: |
| 2017 |
Free,
10 GB
|
Paid,
unlimited |
Stable |
| 2019 |
Free,
10 GB
|
Paid,
unlimited |
Stable |
| 2022 |
Free,
10 GB
|
Paid,
unlimited |
Stable |
| 2025 |
Free,
updated capabilities
50 GB
|
Paid,
unlimited |
* New /
check before use |
* Newer versions not yet tested by Datalab are supported by Microsoft.
-
Express editions of SQL Server are suitable for smaller environments and are free, while Standard and Enterprise editions are recommended for larger installations and use core-based or Server+CAL licensing.
-
The price depends on the agreement and must be confirmed with Microsoft or authorized partners.
 |
IMPORTANT
|
For easier understanding, read the following user instructions related to installation, upgrade, and management of the SQL server and required components. The instructions are divided into chapters:
How to check which SQL version you are using?
In Microsoft SQL Management Studio run:
SELECT @@VERSION
Example result:
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 19045: )
What happens if the SQL version is older than 2017?
Datalab cannot guarantee full compatibility, security, and proper program operation and does not take responsibility for possible errors, security vulnerabilities, data loss, or incompatibilities that may arise from using outdated software.
|
WARNING
Microsoft supports running Microsoft SQL Server on Linux. However, SQL Server on Linux does not provide full functional equivalence with SQL Server on Windows. Some components and functionalities of SQL Server specific to Windows are not available or are limited on Linux. Therefore, PANTHEON is supported only on Microsoft SQL Server running on Windows operating systems.
|