SQL sort order?

[dcornwell]

When installing UCCE I am using the ICMDBA to create the database but am receiving this error:

"The sort order of the SQL Server on this machine is not binary. You may not proceed further"

Does anybody know how you can change the SQL sort order?

[lpezj · Accepted solution]

Hi,

To change SQL Server to 'Binary Order' you will need to reinstall SQL Server and select the 'Custom' installation to config the Binary Order (Latin1_General).

Follow the instructions in this link:

http://www.cisco.com/application/pdf/en/us/guest/products/ps1001/c1225/ccmigration_09186a00804d72f9.pdf

See chapter 10. This SQL installation procedure is valid for all IPCC Enterprise versions in SQL Server 2000.

Hope this helps,

Juan Luis