SQL Native Client 11.0 Configuration

Applies to: SQL Server - Windows only

This section contains the F1 Help articles for the SQL Server Native Client Configuration dialogs in Microsoft SQL Server Configuration Manager. SQL Server Native Client is the network library that client computers use to connect to SQL Server, starting with Microsoft SQL Server.

The settings configured in SQL Server Native Client Configuration are used on the computer running the client program. When configured on the computer running SQL Server, they affect only those client programs running on the server.

These settings do not affect clients connecting to previous versions of SQL Server, unless they are using the client tools starting with SQL Server, such as SQL Server Management Studio.

Important

SQL Server Native Client (SNAC) isn't shipped with:

• SQL Server 2022 (16.x) and later
• SQL Server Management Studio 19 and later

The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new application development.

For new projects, use one of the following drivers:

• Microsoft ODBC Driver for SQL Server
• Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server

For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

In this Section

• SQL Server Native Client Configuration Properties (Flags Tab)

• Client Protocols (SQL Server Configuration Manager)

  • Client Protocols Properties (Order Tab)

  • Client Protocols - Shared Memory Properties (Protocol Tab)

  • Client Protocols - TCP IP Properties (Protocol Tab)

  • Client Protocols - Named Pipes Properties (Protocol Tab)

• Aliases (SQL Server Configuration Manager)

  • New Alias (Alias Tab)

  • <Alias> Properties (Alias Tab)

  • Creating a Valid Connection String Using Shared Memory Protocol

  • Creating a Valid Connection String Using TCP IP

  • Creating a Valid Connection String Using Named Pipes