Configuring SQL Server for Softadmin

Server-Level Configuration

Collation

The server collation, as well as the collation for the master and tempdb databases, must be case-insensitive. It is recommended but not necessary to use a version 100 collation for better sorting and comparison support. For example Finnish_Swedish_100_CI_AS instead of Finnish_Swedish_CI_AS.

For Azure SQL Database, server-level collation is not configurable, which means there is no risk of misconfiguration.

Configuration Per System

SQL Login

Each Softadmin system requires a SQL Server login for the web application to communicate with its database. If there are multiple Softadmin-systems on the same server they should preferably have one login each.

The login must be dbo in the Softadmin database.

The login should not have access to any other databases on the server, unless required by system-specific functionality.

The login may use any authentication method, though SQL authentication is less preferable as its password has to be used in the database connection string. Generally Windows authentication is preferred for the Server edition of Softadmin.

Collation

A Softadmin system requires its database to use a case-insensitive collation. It is recommended but not necessary to use a version 100 collation for better sorting and comparison support. For example Finnish_Swedish_100_CI_AS instead of Finnish_Swedish_CI_AS.

Containment

The Could Edition of Softadmin must use partial containment.

The Server Edition of Softadmin may use partial containment.

Compatibility Level

You should not set the database's compatibility level lower than the oldest supported SQL Server version. See Software requirements for Cloud edition and Software requirements for Server edition.