During an installation of Breeze Server, the Breeze database configuration fails with the following java.sql.Exception:

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer] SET LANGUAGE failed because 'ENGLISH' is not an official language name or a language alias on this SQL Server.


The collation setting on the SQL server is not set correctly. There are several English-language settings available, and the collation setting on the SQL Server must match the collation setting in the Breeze database installation script.


Set the SQL Server collation setting to useSQL_Latin_GENERAL_CP1_C1_AS. See the Microsoft web site for information on SQL Server Collation Fundamentals.

Then, run the Breeze database configuration again using the Breeze Console.