Perhaps it is version dependent but this

https://docs.microsoft.com/en-us/sql...l-server-ver15

Seems to suggest the default is SQL_Latin1_General_CP1_CI_AS.

It does also say ....
The server collation is specified during SQL Server installation.