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

How to change SQL Server to Mixed Mode Authentication using t sql

EXEC xp_instance_regwrite

    N'HKEY_LOCAL_MACHINE'

    , N'Software\Microsoft\MSSQLServer\MSSQLServer'

    , N'LoginMode'

    , REG_DWORD, 2

go

restart sql server