sys.all_columns raises error:Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation

Question

I tried to change default collation of my SQL Server to the default one: "SQL_Latin1_General_CP1_CI_AS" by this command:

sqlservr -m -T4022 -T3659 -s”MSSQLSERVER” -q”SQL_Latin1_General_CP1_CI_AS”

After did this, the query

SELECT * FROM sys.all_columns

It does not work and raises an error:

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.

I found out that the column which causes the error is collation_name. Moreover, creating new databases also face a problem. I can not open "Tables" folder below the database name and that is because it uses the view sys.all_columns to open that folder.

How can I fix this problem?

I also tried this query:

SELECT COLLATION_NAME COLLATE SQL_Latin1_General_CP1_CI_AS
FROM sys.all_columns

but it did not work.

I should say that the system databases have the default collation: SQL_Latin1_General_CP1_CI_AS also knowing this fact may help: There had been some databases with different collation before I changed the default collation and there were no error.

The last thing that I have found out is this view causes the error: sys.system_components_surface_area_configuration.