Sql-server – SqlLocalDB.msi and DBNETLIB / PowerShell SqlServer ServerConnections

sql serverssms

I'm trying to setup a development SQL server using SqlLocalDB.msi which installs a local version of SQL Server 2017.

I can connect to the SQL engine with SSMS (v14.0.17277.0) using MDAC (v10.17134.1).

But, when I open SQL Server Configuration Manager and click on SQL Server Network Configuration (32-bit), it says "There are no items to show in this view."

This appears to be a real problem because when a third-party app I have to use tries to open a connection to the database, it fails withthe following message:

SQLError

But, the Server does exist. Here's a screen shot from SSMS:

SSMS Screenshot

Another clue to what may be going on is that no ServerInstances are listed when when I open an administrator Power Shell and do the following:

PS C:\Windows\system32> import-module "sqlserver"
PS C:\Windows\system32> $smo = 'Microsoft.SqlServer.Management.Smo.'
>> $wmi = new-object ($smo + 'Wmi.ManagedComputer').
>>
>> # List the object properties, including the instance names.
>> $Wmi


ConnectionSettings : Microsoft.SqlServer.Management.Smo.Wmi.WmiConnectionInfo
Services           : {}
ClientProtocols    : {np, sm, tcp}
ServerInstances    : {}
ServerAliases      : {}
Urn                : ManagedComputer[@Name='WINDEV1806EVAL']
Name               : WINDEV1806EVAL
Properties         : {}
UserData           :
State              : Existing

Does anyone know how to get SQL Server Express to work with DBNETLIB?

Best Answer

SQL Express LocalDb is not going to work with the old ODBC driver that comes with Windows. Either download and use a newer ODBC driver, or install the service-based SQL Server Express Edition.