Skip to main content

All Questions

0 votes
2 answers
4k views

Can no longer connect to localdb after updating from Sql Server 2016 to 2019

I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I downloaded and installed SQL Server Express 2019 and uninstalled the older version. ...
FDM's user avatar
  • 101
0 votes
1 answer
1k views

STRING_AGG Not Recognized on V15.0.2 of SQL Server LocalDB

I recently coded a stored procedure on SQL Server 2019 (14.0.3192.2) in AWS that utilized the function STRING_AGG with no issues. When I moved the code to my local test db it complained about that ...
ΩmegaMan's user avatar
  • 409
1 vote
1 answer
2k views

How to troubleshoot "Encryption not supported on the client OLE DB provider "SQLNCLI11" for linked server" error

We are using LocalDb for integration/unit testing of a .NET Core application. I have been using this solution for months and recently started getting sporadic errors. It seems to happen the first time ...
Dude0001's user avatar
  • 111
16 votes
3 answers
35k views

Where to download SQL Server 2019 Express LocalDB Installer MSI from

SQL Server 2019 is released but I there doesn't appear to be a LocalDB version available for download. Does anyone know if there will be a LocalDB release or if 2017 is the last version?
Simon's user avatar
  • 263