
Microsoft has deprecated the legacy "SQL Server Native Client" (SQLNCLI). The official replacement is the Microsoft OLE DB Driver for SQL Server. Do not confuse Driver 18 with the outdated drivers.
Release notes for the Microsoft OLE DB Driver for SQL Server download microsoft ole db driver for sql server 18
This driver ensures high-performance connectivity, modern security (TLS 1.2/1.3), and compatibility with both on-premises SQL Server and Azure SQL Database. By following the steps in this guide, you can confidently deploy Driver 18 in development, test, and production environments. Microsoft has deprecated the legacy "SQL Server Native
Close SQL Server Management Studio (SSMS), Visual Studio, IIS (Internet Information Services), or any custom applications connecting to SQL Server. Release notes for the Microsoft OLE DB Driver
| Requirement | Detail | |--------------|--------| | OS | Windows 10/11, Windows Server 2016/2019/2022 | | Architecture | x86, x64 (ARM64 not natively supported) | | Prerequisites | Microsoft Visual C++ Redistributable 2017+ | | SQL Server | 2012, 2014, 2016, 2017, 2019, 2022 + Azure SQL |
.NET developers should use Microsoft.Data.SqlClient or System.Data.SqlClient . However, if you have a legacy .NET app using System.Data.OleDb , it will work.