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.
- Select New Query then enter
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.