Database settings

Every iCore system uses a database. The database settings for a system can be accessed from the Create new system and Local settings – systems dialogs in the Administrator tool.

Properties

* = Mandatory property

Server*	Machine where the database is located. Select a machine from the drop-down list. The server name may also be entered by typing the name directly in the field.
Authentication	The authentication method of the iCore system. See also Remarks below.
Username	User name to log on to the database. See also Remarks below.
Password	Password to log on to the database.
Database name*	Name of the database. Select a database from the drop-down list. The database name may also be entered by typing the name directly in the field. The iCore system information, including iCore system name, is fetched from the selected database.
Command timeout	The time in seconds to wait for a database command to execute. Specifies the time to be waited before terminating the attempt to execute a database command and generating an error. A value of 0 indicates no limit, and is to be avoided as this would allow an attempt to execute a command to wait indefinitely. (This property is the cumulative time-out for all network reads during command execution or processing of the results. A time-out may still occur after the first row is returned, and does not include user processing time, only network read time.)
Transaction timeout	The number of seconds after which a database transaction times out and is aborted. There is a maximum value for this timeout determined by the .NET framework for each computer. Setting this value to a higher value than the maximum timeout for the computer will produce a warning dialog.
Use multi-subnet failover	Specifies whether to increase performance when searching for database replica during failover (if the specified database uses Always On Availability Group).

Remarks

Authentication

The following options are available:

• Windows authentication (default)
  The iCore system uses the Windows credentials of the current user to log on to the database.
• SQL Server authentication
  The iCore system uses SQL credentials to log on to the database.

Using Windows authentication is safer and more convenient but it can also cause confusion since iCore executes in separate "contexts" (depending on who the Windows user is).

• "Tool" context – iCore executes as the user currently logged into Windows.
• "Server" context – iCore executes as the user specified in iCore service.

This means that a problem caused by a "server" user and a "tool" user having different database authorization levels can be difficult to fault-trace. For example, when installing the iCore service to run as "Local System" (the default setting), at least two accounts will need access to the SQL Server: The currently logged-on user and the 'NT AUTHORITY\SYSTEM' account. Both need to be configured in SQL Server.

note

If you are connecting to an Azure SQL database, you can only use SQL Server authentication.

note

When using Windows authentication, create a "iCore" user group in Windows on the local computer which includes all users that are meant to have access to the SQL server. 

Username

note

The user name format for logging on to an Azure SQL database is username@servername. For example, if the server is iCoreAzure.database.windows.net, the user name is iCore_User@iCoreAzure.