Open Documentation Menu

Using a Microsoft SQL Server database

Please note the following for the use and configuration of a Microsoft SQL Server database:

  • To establish a connection with the database, please enable the TCP/IP protocol for the SQL server.

  • The tables are created in the default schema of the administrative database user.

  • The administrative user must be authorized to create tables, views and indexes in his/her default schema.

  • The runtime user must use the same default schema as the administrative user.

  • In this schema, the runtime user needs the permissions SELECT, INSERT, UPDATE and DELETE.

  • The two switches ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT must be configured in the database with the value ON.