Installing Dispatcher Paragon Management Server on server with specific database collation for MS-SQL database

If you are installing Dispatcher Paragon on server with Turkish locale using external MS SQL server 2012, you have to create database with specific collation settings first.

Following steps require already installed MS-SQL server.

  1. Before Dispatcher Paragon installation described in article Install the Dispatcher Paragon Management Server, following steps are required to create database with specific collation.

  2. Open SQL Server Management Studio and create new database.

    images/download/attachments/284927424/SQL01.png-version-1-modificationdate-1575367806297-api-v2.jpg


  3. On General tab enter SQDB6 as a Database name.

    images/download/attachments/284927424/new-database-version-1-modificationdate-1575367806310-api-v2.png


  4. Switch to Options tab and set specific Collation.

    Example: For Turkish locale set SQL_Latin1_General_CP1250_CI_AS .

    Then click OK and new database will be created.

    images/download/attachments/284927424/SQL03.PNG-version-1-modificationdate-1575367806267-api-v2.jpg

  5. Now you can install SafeQ according to Install the Dispatcher Paragon Management Server. In step 4.b. enter connection for external MS-SQL server. In step 4.c. enter database names of already created databases (SQDB6). Install wizard will connect to created databases and confirm connection.