Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

SQL sort order?

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
Gold

Re: SQL sort order?

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

1 REPLY
Gold

Re: SQL sort order?

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

428
Views
0
Helpful
1
Replies
CreatePlease to create content