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.

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy