Follow these steps to change the SQL collation
0) stop the sql service
1) navigate to the bin folder in CMD of the sql server
2) run the cmd below
sqlservr -m -T4022 -T3659 -s"SQL2017" -q"Latin1_General_CI_AS" (change the SQL instance and the collation you want to change it in to)
3) exit the cmd safely (after executing the cmd command above, you will be prompted to exit SQL server, hit YES to do so)
4) start service
5) check collation in MS