TechNote

Breeze install fails with java.sql.Exception: SET LANGUAGE failed because 'ENGLISH' is not an official language name or a language alias on this SQL Server

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 (http://localhost:8510/).

Search Support

---