Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Orion Platform > Supported SQL collations

Supported SQL collations

Table of contents

 

Updated: January 25, 2018

Overview

Using a supported database collation is important for some functions of Orion Platform products. For example, in unsupported collations, DateTime formats may vary, and this can cause errors.

SolarWinds does not support case-sensitive databases.

SolarWinds supports the following Orion SQL Database collations:

  • English with collation setting SQL_Latin1_General_CP1_CI_AS (most commonly used)
  • English with collation setting SQL_Latin1_General_CP1_CS_AS
  • German with collation setting German_PhoneBook_CI_AS
  • Japanese with collation setting Japanese_CI_AS
  • Simplified Chinese with collation setting Chinese_PRC_CI_AS

Environment

Orion Platform versions running 2015.1 or later

Steps

If are not using a supported collation, you must re-install your instance of SQL with a  supported collation.

  1. Create a backup of your data.
  2. Re-install your SQL instance with a supported collation.
  3. Re-create your tables.
  4. Import your data.

It is also possible to change SQL Server Collation manually via cmd prompt command.

Changing the SQL Server Collation manually requires that your DBA needs to take ownership. SolarWinds cannot take these steps as there are risks involved and DBA will need to process with care.

 

The following steps describe how to edit the SQL Server Instance Collation without reinstalling. The steps are useful when you have installed a new SQL Instance and haven't attached or created a database yet. 

  1. Check the collation in SQL Management Studio.
    For example, your collation could be Danish_Norwegian_CI_AS.
  2. To edit the SQL Instance Collation, stop the SQL Server Instance. You can use Services.msc, cmd or SQL Management Studio to do this.

    NET STOP "MSSQLServer"

  3. Execute the command below. 
    sqlservr -m -T4022 -T3659 -s"MSSQLServer" -q"SQL_Latin1_General_CP1_CI_AI"

    The parameter -s is only necessary if more than one SQL Server instance exists on the target machine. Parameters used: 
    • [-m] single user admin mode 
    • [-T] trace flag turned on at startup 
    • [-s] sql server instance name 
    • [-q] new collation to be applied

     

    At the end of a long SQL message, you can find the information that the Collation has updated successfully.

  4. Close the cmd prompt window after the execution ends.

 

Last modified

Tags

Classifications

Public