SQL collation of a new server

I have a new server (Windows 2022) and I need to install SQL Server 2022 with the collation to be Latin1_General_CI_AS, but in the setup there is no option to allow this, see the screenshot.

How can I set the collation in SQL to Latin1_General_CI_AS when I am forced to accept Latin1_General_CP1_CI_AS?

SQL Server Install Collation Options:

I have insured the locale and timezone on the server is correct (UK) compared server install to another identical server which has as default Latin1_General_CI_AS like I need

Checked the server default codepage (437)

but in the setup there is no option to allow this, see the screenshot

Your screenshot shows the list of deprecated, legacy, ancient, "SQL collations". Do not use these (and Microsoft should stop making these the defaults today, as it contradicts their own documentation).

The Latin1_General_CI_AS collation can be selected by first selecting the top radio-button for "Windows collation designator and sort-order".

For Latin1_General_CI_AS you'll want:

• Collation designator: Latin1_General.
• Case-sensitive unchecked (CI = Case-insensitive)
• Accent-sensitive: checked (AS = Accent-sensitive)

Leave all other options unchecked.

However, as it's 2024 now, consider using a less-antiquated collation, and take advantage of UTF-8 support while you're at it, so consider using Latin1_General_100_CI_AS_SC_UTF8:

• Collation designator: Latin1_General_100.
• Case-sensitive unchecked (CI = Case-insensitive)
• Accent-sensitive: checked (AS = Accent-sensitive)
• Supplementary characters: checked (Needed for UTF-8 support)
• Storage option: UTF-8

Leave all other options unchecked.