LocalDB from the express 2019 install doesn't seem to support compatibility level 140.

Question

LocalDB from the express 2019 install doesn't seem to support compatibility level 140.

SimplyConphuzed 21

Is there any way to get a version of LocalDB that supports compatibility level 140? We use LocalDB in some unit tests, but since requiring compatibility level 140, they don't work:

Valid values of the database compatibility level are 100, 110, 120, or 130.

Any thoughts?

SimplyConphuzed 21 Reputation points

2021-06-16T14:52:30.06+00:00

Select @@version on a localdb database installed from the 2019 installer yields:

Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
Oct 28 2016 18:17:30
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows 10 Enterprise 6.3 <X64> (Build 15063: )
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2021-06-18T03:43:00.967+00:00

Hi @SimplyConphuzed ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Accepted answer

1 additional answer

Your answer

SimplyConphuzed 21 Reputation points

2021-06-16T14:52:30.06+00:00

Select @@version on a localdb database installed from the 2019 installer yields:

Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
Oct 28 2016 18:17:30
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows 10 Enterprise 6.3 <X64> (Build 15063: )
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2021-06-18T03:43:00.967+00:00

Hi @SimplyConphuzed ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

CathyJi-MSFT 22,396 Microsoft External Staff

Hi @SimplyConphuzed ,

> Select @@version on a localdb database installed from the 2019 installer yields:
>Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)

You made a confuse about your environment. You have a SQL 2016 (130) environment, not SQL 2019 (150) environment. Your local DB is installed from SQL server 2016 installation package not SQL 2019.

SQL 2016(130) could not compatibility SQL 2017 (140)

Please download SQL server 2019 Express setup file from this MS link. Then install SQL server 2019 version Local DB.

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

SimplyConphuzed 21 Reputation points

2021-07-07T23:52:28.633+00:00

Sorry for the lack of response, I got distracted by other fires.

I did exactly this, which is why I'm confused and posting here. I uinstalled all versions of sql, installed from that same link you posted, and still have this problem. I'm going to try on another computer that's never had sql on it.
SimplyConphuzed 21 Reputation points

2021-07-08T00:40:43.663+00:00

It works as expected on another computer. Trying again on my main development box...

Completely uninstalled and re-installed, and this time it worked. Don't know why. Followed exactly the same steps. Anyway, done monkeying around...

Answer 2

Erland Sommarskog 122K MVP Volunteer Moderator

You have SQL 2016, so it does not obviously store compatibility level 140 which corresponds to SQL 2017.

You need to install LocalDB for SQL 2017 or SQL 2019.

Share via

LocalDB from the express 2019 install doesn't seem to support compatibility level 140.

1 additional answer

Your answer