I’m troubleshooting why this labelling software Bartender I’m using on a Server 2019 machine can’t connect to a SQL Server 2019 database running on the same machine using the up-to-date recommended OLE DB DRIVER (MSOLEDBSQL
), but only using the deprecated OL DB PROVIDER (SQLOLEDB
).
I created a blank .udl
file to initiate the data link properties menu to show the list of the OLE DB providers and select the up to date driver
And when I navigate to the server selection drop down box the driver fails to see the server:
The SQL Server Windows services are correctly running and as seen here when using the deprecated driver the server is visible:
I have updated MSOLEDBSQL
to the latest version but am not sure what other solutions I can try.
EDIT: Attempted to directly type the server name and received an error. Pictured:
see conversation thread
4