7.2 Ensure Asymmetric Key Size is set to 'greater than or equal to 2048' in non-system databases

Information

Microsoft Best Practices recommend to use at least a 2048-bit encryption algorithm for asymmetric keys.

The RSA_2048 encryption algorithm for asymmetric keys in SQL Server is the highest bit-level provided and therefore the most secure available choice (other choices are RSA_512 and RSA_1024 ).

Solution

Refer to Microsoft SQL Server Books Online ALTER ASYMMETRIC KEY entry:

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-asymmetric-key-transact-sql

Impact:

The higher-bit level may result in slower performance, but reduces the likelihood of an attacker breaking the key.

Encrypted data cannot be compressed, but compressed data can be encrypted. If you use compression, you should compress data before encrypting it.

See Also

https://workbench.cisecurity.org/benchmarks/14058

Item Details

Category: ACCESS CONTROL, IDENTIFICATION AND AUTHENTICATION, SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|AC-17(2), 800-53|IA-5, 800-53|IA-5(1), 800-53|SC-8, 800-53|SC-8(1), CSCv7|14.4

Plugin: MS_SQLDB

Control ID: 311c837109bf6b02dc34e32228160fe1ce11ebb5bbdcab1b69a5ce70bc4f13f2