Database systems

Sage CRM supports cloud and on-premise database solutions provided by Microsoft.

Microsoft Azure SQL

Sage CRM supports the following Azure SQL solutions and resource types:

Supported solution

Supported resource type
Microsoft Azure SQL Database Database server

Before installing Sage CRM, make sure that the target Azure SQL Database server exists.

To create a new Azure SQL Database server compatible with Sage CRM: 

  1. Go to https://portal.azure.com/#create/Microsoft.AzureSQL.

  2. Under SQL databases, from the Resource type list, select Database server.

  3. Select Create and follow the steps to create a new Azure SQL Database server.

Consider the following limitations:

  • You cannot use the Sage CRM Setup to select an existing database in Azure SQL. At the moment, the Setup can only create a new database on an existing Azure SQL Database server.

  • Sage CRM Setup cannot migrate data from an existing on-premise Microsoft SQL Server database to Microsoft Azure SQL.

Microsoft SQL Server

Before installing Sage CRM, make sure you have Microsoft OLE DB Driver 18 for SQL Server installed on the SQL Server that will be hosting the Sage CRM database.

Download Microsoft OLE DB Driver 18 for SQL Server

If you don't have this driver installed, the Sage CRM Setup cannot connect to the SQL Server.

Sage CRM supports the following Microsoft SQL Server versions:

  • Microsoft SQL Server 2019 (Standard, Enterprise, or Web) with Cumulative Update 16 and earlier

  • Microsoft SQL Server 2017 (Standard or Enterprise) with Cumulative Update 29 and earlier

  • Microsoft SQL Server 2019 Express supplied in the Sage CRM installation package

Microsoft SQL Server 2019 Express is installed with the following parameters:

  • Password of the sa account: SageCRM#20xx

  • Instance name: CRMEXPRESS2019

  • Port number: selected automatically

Microsoft SQL Server 2019 Express has the following limitations:

  • Sage does not recommend this SQL Server version for environments that exceed five Sage CRM users.

  • Maximum memory utilized (per instance of SQL Server Database Engine): 1 GB

  • Maximum relational database size: 10 GB

For detailed information about all Microsoft SQL Server 2019 Express limitations, see Editions and supported features of SQL Server 2019 (15.x) on Microsoft SQL documentation.

If you use Microsoft SQL Server 2019 Express, Sage Support will address only those issues that can be reproduced on any other supported SQL Server edition listed above.