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.