Error when start an instance of SQLLOCQLDB 2017 on windows 7 64bit (entry point not found except)

Question

I tried to start an instance of SQLLOCALDB 2017 on win7 (x64) but this message box Appears :

"The procedure entry point BCryptKeyDerivation could not be located in the dynamic link library bcrypt.dll"

Anybody knows it's reason?

more info from CMD:

Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\hashem-7-x64>SQLLOCALDB INFO MSSQLLocalDB

C:\Users\hashem-7-x64>SQLLOCALDB VERSIONS Microsoft SQL Server 2017 (14.0.1000.169)

C:\Users\hashem-7-x64>SQLLOCALDB START MSSQLLOCALDB Start of LocalDB instance "MSSQLLOCALDB" failed because of the following error: Error occurred during LocalDB instance startup: SQL Server process failed to sta rt.

C:\Users\hashem-7-x64>

Answer 1

I had the same problem and I resolved it by uninstalling Sql Server LocalDB 2017 and installing the 2014 version.

Apparently the 2017 version is not compatible with Windows 7.

Answer 2

SQL Server 2017 Express LocalDB isn't supported on Windows 7. The SqlLocalDB.msi installer for me but when I tried to start an instance it would give the "BCryptKeyDerivation could not be located" error. Anecdotally the 2016 version is supposedly not supported, but it installed and default instances run for me.

Per Microsoft :

Supported Operating System:

Windows 10 , Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

Some additional information indicating that you'll need at least Windows 8

BCryptKeyDerivation function

The BCryptKeyDerivation function derives a key without requiring a secret agreement. It is similar in functionality to BCryptDeriveKey but does not require a BCRYPT_SECRET_HANDLE value as input.

Minimum supported client

Windows 8 [desktop apps | UWP apps]

Minimum supported server

Windows Server 2012 [desktop apps | UWP apps]