解决SAP SQL安装时的 collation 错误与升级建议

Symptom


When defining the wrong collation during manual installation of MSSQL Server 2005 or MSSQL 2008 or MSSQL 2012, in certain situations it might cause functional problems. Examples:

1. When trying to use any functionality of Drag & Relate, the following error message will be displayed: 'No matching record found'.

2. When runing "Sales\Purchase analysis report" for Business Partner, the report might not retrieve any results eventhough it should.


Cause

Consulting Note


Solution

The latest version of any documentation can be found at http://service.sap.com/smb/sbo/documentation.

Please make sure to choose collation setting of: SQL_Latin1_General_CP1_CI_AS
when installing MSSQL 2005 / 2008 / 2012 Server or start the SAP Business One Installer and follow the wizard for installing the SQL Server once to SQL Server could be found.
In case you are planning to upgrade your existing MSSQL 2005 / 2008 to MSSQL 2012, we recommend to change the collation settings prior the upgrade.

In order to check what the collation is set to in your server, please run the following query:

Collation of your Server:
select SERVERPROPERTY ('collation')
(This query gets the collation settings of MSSQL Server's System Database "Master")
Expected answer : SQL_Latin1_General_CP1_CI_AS