Creation of the database, login, and user

Setting up the database can be performed through a batch file or manually using the Microsoft SQL Server Management Studio program. Both methods are described below. ImageMaster requires a database, a login and a corresponding user with the following settings:

• The following requirements apply for ImageMaster concerning the collation setting:

  • A case-sensitive collation is required.

  • SQL Server collations (which start with the prefix “SQL_”) are not supported by ImageMaster! 1 Microsoft states that SQL Server collations in MS SQL server are only supported for backward compatibility, but should not be used for new development work (https://docs.microsoft.com/en-us/sql/t-sql/statements/sql-server-collation-name-transact-sql?view=sql-server-ver15).

  • Full functionality for ImageMaster has been approved with the collation “Latin1_General_CS_AS”.

    It is strongly recommended using this collation as other collations were reported to cause unexpected behavior with serious dysfunctions.

• The option READ_COMMITTED_SNAPSHOT must be set to ON in the database;

  The user must be a member of the following roles or have the named permission (see Manual database setup with Microsoft SQL Server Management Studio):

  • SqlJDBCXAUser role

  • db_datareader role

  • db_datawriter role

  • db_ddladmin role

  • EXECUTE permissions