Microsoft SQL Server Database Best Practices

For best results, configure and maintain your Microsoft SQL database according to the vendor's requirements and use the Jive best practices.

Installation

Case Sensitivity

SQL Server instance default collation is case insensitive, accent sensitive. If database collation is not specified, the instance collation will be used. Latin1_General_CI_AS is recommended for typical installations. In special cases where the Jive Platform is configured to allow case-sensitive usernames (for example, where jsmith and JSmith would be different logins), Latin1_General_CS_AI is required so that case sensitivity may be utilized in indexing and string searches.

You'll find more information on adjusting SQL Server settings in the SQL Server documentation: Setting and Changing the Server Collation Setting and Changing the Database Collation.