Database Management Systems

The Express editions of SQL Server are supported for evaluation, development, and demonstration purposes only. They are also supported for the Meridian Enterprise Server configuration database only when Meridian Explorer is not configured. We do not recommend it for any environments. Accruent does not routinely test the Express editions for compatibility, performance, stability, or scalability. When Meridian Explorer is configured, the Standard or Enterprise edition of SQL Server must be used. SQL Server failover clusters are supported.

Meridian Explorer only supports the 64-bit versions of Microsoft SQL Server.

Database collation determines if queries and T-SQL script are case-sensitive or case-insensitive. Meridian Explorer requires case-insensitive database collation, which can be set either on the server level or on the database level. To set the collation at the server level, see Set or Change the Server Collation. To set the collation at the database level, see Set or Change the Database Collation.

The Full Text Search component is not installed by default, but is required on servers where repositories will be created. The Full Text Search component is only included in the following editions of SQL Server: Express with Advanced Services, Standard, and Enterprise editions.

Microsoft SQL Server provides a FILESTREAM feature for higher performance that we recommend and is enabled by default during repository creation. Before using this feature, we strongly recommend that you fully understand the advantages, limitations, and implications of the feature by studying the Microsoft SQL Server documentation. For an overview, see Binary Large Object (Blob) Data (SQL Server) on Microsoft TechNet.

Beginning with Meridian Enterprise 2018 R2 Update 1, the Microsoft OLE DB Driver for SQL Server must be installed on the Meridian server to create vaults stored in any version of SQL Server. This driver adds support for the latest TLS 1.2 standards and is backward compatible with the SQL Server Native Client but is not included with the client. The driver is required whether TLS 1.2 is used or not.

For more information about and to download the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), which replaces the legacy OLE DB Provider for SQL Server (SQLOLEDB), see:

• Announcing the new release of OLE DB Driver for SQL Server

• Released: Microsoft OLE DB Driver for SQL Server

• Microsoft OLE DB Driver for SQL Server

• Download Microsoft OLE DB Driver for SQL Server