Last updated on
Dec 22, 2021
Issue
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.
Reason
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.
Solution
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.