SV-265870r1138543_rule
V-265870
SRG-APP-000456-DB-000400
SQL6-D0-018300
CAT I
10
Remove or decommission all unsupported software products.
Upgrade unsupported DBMS or unsupported components to a supported version of the product.
Review the system documentation and interview the database administrator.
Identify all database software components.
Review the version and release information.
Verify the SQL Server version via one of the following methods:
Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.
Or, from SQL Server Management Studio:
SELECT @@VERSION;
More information for finding the version is available at the following link:
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/find-my-sql-version
Access the vendor website or use other means to verify the version is still supported.
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2016
If the installed version or any of the software components are not supported by the vendor, this is a finding.
V-265870
False
SQL6-D0-018300
Review the system documentation and interview the database administrator.
Identify all database software components.
Review the version and release information.
Verify the SQL Server version via one of the following methods:
Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.
Or, from SQL Server Management Studio:
SELECT @@VERSION;
More information for finding the version is available at the following link:
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/find-my-sql-version
Access the vendor website or use other means to verify the version is still supported.
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2016
If the installed version or any of the software components are not supported by the vendor, this is a finding.
M
3993