To change the collation at server level I believe you need to rebuild the master database, to handle the query:

SELECT ID

FROM ItemsTable

INNER JOIN AccountsTable

WHERE ItemsTable.Collation1Col COLLATE DATABASE_DEFAULT

= AccountsTable.Collation2Col COLLATE DATABASE_DEFAULT