cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
691
Views
0
Helpful
1
Replies

SQL sort order?

dcornwell
Level 1
Level 1

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?

1 Accepted Solution

Accepted Solutions

lpezj
Level 7
Level 7

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

View solution in original post

1 Reply 1

lpezj
Level 7
Level 7

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: