SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

by Pelin   Last Updated July 16, 2018 15:00 PM

I am installing an OLT Software that requires Windows SQL Server 2008.

I am getting this error below;

The database sort order must be "binary sort". Please run the Transact-SQL command sp_helpsort to check the current database sort order.

Output of sp_helpsort is;

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Page 1252 for 
non-Unicode Data

How could I change sort order to "binary sort" in order to proceed installation?


Answers 1

You need to either reinstall SQL and change the collation during the installation or rebuild the system databases to change the collation.


Jason Cumberland
Jason Cumberland
July 18, 2018 21:31 PM

Related Questions

How can I get SeSecurityPrivilege enabled?

Updated April 08, 2017 09:00 AM

Migrate windows server 2008 r2 and 2012 to 2016

Updated December 31, 2017 17:00 PM