Database fields



Database user ID

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.

Database password

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.

Use integrated Windows NT security

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.

Default database server

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

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.

Default database

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

Query timeout (sec)

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

Port number

SQL server port number specified during the install. The default value is 1433.

Fields that display for multi-server Sage CRM deployments:




Distributed CRM web server names

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

Distributed CRM web server IP addresses

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: 

Do load balancing

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

DTLS server name

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.

Fully qualified CRM web server names

The complete domain name for web servers, consisting of the hostname and domain name. An example is, where the hostname is “mymail” and the host is located in the domain “”.

If any of these servers require HTTPS, the server name must be the name specified on the server certificate.