This is the user ID that is used to connect to the database. This user must exist in Microsoft SQL Server or Azure SQL solution.

This is the database password in the Microsoft SQL Server or Azure SQL solution.

Make sure that your password:

• Does not start with an at sign (@) or dollar sign ($).

• Does not contain an equal sign (=) or quotation marks (").

  Sage CRM doesn't support these characters in database passwords, even though on-premises Exchange Server, cloud-based Exchange Online, or Azure SQL solution allows these characters.

• Does not exceed 128 characters.

This check box works with Microsoft SQL Server only.

When you select this check box, Sage CRM uses the IUSR account to connect to the database. Values in Database user ID and Database password are ignored.

System administrators must make sure that IUSR is added as a user to Microsoft SQL Server and has access to the database.

To specify a Microsoft Azure SQL server, enter its fully qualified domain name. For example: myserver.database.windows.net.

To specify a Microsoft SQL Server, enter its name or IP address. For more information, see Connecting to the database server using its IP address.

This is the name of the database on your database server.

The maximum amount of time that a query is allowed run on the database server before a timeout error is displayed in Sage CRM.

The names of the Sage CRM servers in the cluster, separated by semicolons.

A list of IP addresses from which Sage CRM accepts incoming requests for user count. When specifying IP addresses, use a semicolon as a separator.

This field accepts an asterisk (*) as a wildcard, for example: 
192.0.2.*

• True. Sage CRM performs load balancing.
• False. A load balancing application performs load balancing.

The name of the server on which all Table Level Scripts are performed.

If this is an HTTPS server, the server name must be the name specified on the server certificate.