You are viewing limited content. For full access, please sign in.

Question

Question

Supported Versions of SQL vs. Supported Versions of Compatibility Levels

Administration
Updated July 22, 2022
asked on July 21, 2022

The Laserfiche documentation mentions what versions of MS SQL are supported by the different Laserfiche products. Is it supported to have a database on a supported version of SQL Server, but have the compatibility level of a database set to a lower version?

0 0

Answer

SELECTED ANSWER
replied on July 22, 2022 • Show version history

The SQL Server database compatibility level for a Laserfiche application database can be lower than the SQL Server version hosting the database. The compatibility level must be equal to or greater than the compatibility level for the minimum supported SQL Server version specified in a Laserfiche application's system requirements.

Ex.: Laserfiche Server 11 has the following database requirements:

  • Database engine: Microsoft SQL Server 2014 Service Pack 3, Microsoft SQL Server 2016 Service Pack 2, Microsoft SQL Server 2017, Microsoft SQL Server 2019

Running a Laserfiche Server 11 repository database on SQL Server 2019 (default 150) at compatibility level 120 (SQL Server 2014) - Supported.

Running it at at compatibility level 110 (SQL Server 2012) - Unsupported.

Note: Unsupported doesn't necessarily mean "won't work"; you do so at your own risk because we don't officially test that configuration, and Laserfiche Support may not be able to help you until the system is in a supported configuration.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...