Installing Microsoft SQL Server Software

The Microsoft SQL Server software is required on the database servers. See the table in Supported Prerequisite Software Versions.

Prerequisistes

When installing the Microsoft SQL Server software note the following issues:

  • To apply the security-level high measures, set up encryption for the SQL Server to ensure that data is transmitted encrypted. To set up encryption, use the SQL Server Configuration Manager.

    1. Expand SQL Server Network Configuration and right-click the protocols for the server.

    2. Click Properties.

    3. On the Certificate tab, configure the Database Engine to use the certificate.

      When the Force Encryption option for the Database Engine is set to Yes, all client/server communication is encrypted and clients that cannot support encryption are denied access.

    4. Restart the SQL Server.

  • Before starting the Microsoft SQL Server software installation, check that all necessary Microsoft security patches and hotfixes are installed.

  • If the Reporting (with MS Reporting Services) application is part of your system, install also the Analysis Services and Reporting Services components of SQL, see Installing SQL for Reporting. Reporting with SAP BO requires only basic SQL.

  • If two SQL databases are replicated, make sure that the character set, sort order, unicode collation and sensitivity settings are same in both systems, otherwise replication may fail.

  • If Sinch Contact Pro databases are installed in different databases, MSDTC must be enabled.

  • Use recovery mode = full (as it enables incremental backups that save a lot disk capacity) for all other databases except for the DSArea and Monitoring databases, they should use the simple mode.

  • For Reporting-specific SQL issues, see the section Installing SQL for Reporting Services.

  • In ASP environment, install different customer systems in different SQL instances.

  • The availability group function is not supported. Only an SQL Server cluster is supported.

Databases in Production Use

When installing databases for production use, consider the following recommendations. In small systems for demo and training purposes you can ignore these recommendations:

  • Install the database and transaction log on different physical disks.

  • Define in the SQL Management Studio:

    • an appropriate growth increment size of database data file for each database. For example, use 200 MB for Operative Database, and 20 MB for other databases.

    • Define an appropriate growth increment size of database transaction log file. For example, use 200 MB for Operative Database, and 20 MB for other databases.

Installation

Install Microsoft SQL with default installation but the following items you need to define yourself:

  • Feature Selection: Select all options but Business Intelligence Development Studio, Integration Services, Client Tools SDK, SQL Client Connectivity SDK, Microsoft Sync Framework. Analysis Services and Reporting Services are required only on database servers where Reporting application will be installed.

  • Instance Configuration: Select the Named Instance and define its name, ID, and instance root directory.

  • Server Configuration: Define the Service Account to run the services, and the Collation used:

    Note:

    Software supports only case insensitive / accent sensitive collations. Use one of options listed below:

    Albanian_CI_AS

    Arabic_CI_AS

    Cyrillic_General_CI_AS

    Chinese_PRC_CI_AS

    Chinese_PRC_Stroke_CI_AS

    Chinese_Taiwan_Bopomofo_CI_AS

    Chinese_Taiwan_Stroke_CI_AS

    Croatian_CI_AS

    Czech_CI_AS

    Danish_Norwegian_CI_AS

    Estonian_CI_AS

    Finnish_Swedish_CI_AS

    French_CI_AS

    Georgian_Modern_Sort_CI_AS

    German_PhoneBook_CI_AS

    Greek_CI_AS

    Hebrew_CI_AS

    Hungarian_CI_AS

    Hungarian_Technical_CI_AS

    Icelandic_CI_AS

    Japanese_CI_AS

    Korean_Wansung_CI_AS

    Latin1_General_CI_AS

    Latvian_CI_AS

    Lithuanian_CI_AS

    Polish_CI_AS

    Romanian_CI_AS

    Slovak_CI_AS

    Slovenian_CI_AS

    SQL_Latin1_General_CP1_CI_AS

    Modern_Spanish_CI_AS

    Traditional_Spanish_CI_AS

    Thai_CI_AS

    Turkish_CI_AS

    Ukrainian_CI_AS

    Vietnamese_CI_AS

    To define collation, choose the Collation tab:

    1. Choose the collation that corresponds the language used in the system.

    2. Click the Customize button

    3. Select Accent-sensitive and click OK:

  • Database Engine Configuration:

    • Select Windows authentication, and enter the password.

    • Specify the SQL Server administrators

  • Analysis Services Configuration: on those SQL servers only that are used for Reporting: Specify the users that have administrative permissions for Analysis Services.

  • Reporting Services Configuration: on those SQL servers only that are used for Reporting: Select the option Install, but do not configure the report server. For more information, see Installing Reporting.