Error:
Getting the following error when trying to create linked servers (from an old script) on SQL Server 2019.
The requested OLE DB provider SQLNCLI10.1 is not registered.
Fix:
In the linked server script, replace @provider=N’SQLNCLI10‘ with @provider=N’SQLNCLI‘
Comments