SQL Server 'Cannot create an instance of OLE DB provider "SQLNCLI11" for linked server' after patching

cetgtptt 于 2023-02-18 发布在 SQL Server

关注(0)|答案(2)|浏览(170)

One of our servers went for a reboot last night after doing OS and SQL Server patching (SQL Server 2016 latest CU). Since then any call to a linked server from the patched server fails with the above error.

Other servers can still connect to the patched server, just outbound doesn't seem to work at all.

We also have an issue with the SQL Server Browser service wont start "stopped unexpectedly", although not sure if its related

Any help greatly appreciated

sql-server

来源：https://stackoverflow.com/questions/75458854/sql-server-cannot-create-an-instance-of-ole-db-provider-sqlncli11-for-linked

2条答案

按热度按时间

mf98qq941#

Microsoft OLEDB Providers - part of the SQL Server Native Client (SNAC) are deprecated:

SQLNCLI10
SQLNCLI11

You need to install Microsoft OLE DB Driver for SQL Server:

MSOLEDBSQL

The switch happened in 2018. You can read about it here:

赞(0）回复(0）举报 2023-02-18

93ze6v8z2#

Ok people, problem solved.

One of the updates tried to upgrade the OLEDB connectors, ran into a problem and bailed. It had already deleted the DLLs for the drivers though.

Finding the drivers on the Dev server and copying them across solved the issue.

For those bleeding on about SNAC on being on SQL12, that was it's release version. It's been a staple ever since and is installed as standard by SQL16. It's not untill 2022 that it's replaced

赞(0）回复(0）举报 2023-02-18

我来回答

SQL Server 'Cannot create an instance of OLE DB provider "SQLNCLI11" for linked server' after patching

2条答案

相关问题

热门标签

最新问答