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:
But, the Server does exist. Here's a screen shot from SSMS:
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.