Configuring Microsoft SQL Server

The database setup is done on the Microsoft SQL server.

First read the pre-installation notes for SQL Server provided in this documentation.

The SQL Server installation has to be an AccentSensitive, CaseInsensitive, Unicode-ready installation.

  • If you are performing a fresh SQL Server installation, make sure that in the Database engine Collation settings, Accent-sensitive is selected and Case-sensitive is not selected.
  • The typical Content Manager collation is SQL_Latin1_General_CP1_CI_AS (not the often mistaken collation Latin1_General_CI_AS). Depending on the SQL Server version, the collation SQL_Latin1_General_CP1_CI_AS is also displayed as Dictionary order, caseinsensitive, for use with 1252 Character Set.

  • You can check the collation name by issuing a query in SQL Server Management Studio connected to your server.
    • Select New Query then enter select ServerProperty('Collation').
    • Select Execute.
    • Verify that the result shows an Accent-sensitive (AS), Case-insensitive (CI) collation name.

      For more information refer to Collations in the SQL Server help files.

We recommend authentication based on named SQL Server login ID and on Windows accounts.

  • Check or modify authentication in SQL Server Management Studio, right-click ServerName, then click Properties and select Security on the left pane.
  • In the Server authentication pane on the right, select SQL Server and Windows Authentication Mode.

SQL Server Agent is part of the SQL Server software.

  • Check that this Windows Service is set to automatically start upon server reboot.

    In the Control Panel select System and Security then Administrative Tools then open Services.

  • Verify that SQL Server Agent startup type is Automatic.