How To Do SQL Server Native Client Installation?

638 Asked by Amitjaisawal in SQL Server , Asked on Nov 17, 2022

App team had suggested reinstalling SQL server native client for SQL server 2012. My question here is can I download the SQL server native client installation file and just install over the existing native client?

Or do I need to remove the existing native client and install it again?

Answered by Alison Kelly

You can install Microsoft SQL Server Native client software on the Rendition Engine server to enable communication with a Microsoft SQL Server database when using a non-default port.

The following procedure describes the minimum options for installing the Microsoft SQL Server Native client. Before you begin, see the Microsoft SQL Server Native client Installation Guide that was provided with the client software for complete instructions and pre-installation requirements.

To install the Microsoft SQL Server Native client:

Log on with the appropriate local account to install and launch the Microsoft SQL Server Client.

From the SQL Server Setup media, install the following Shared Features:

Client Tools Connectivity

Management Tools - Basic

In SQL Server Configuration Manager, create a new alias in SQL Native Client Configuration (32-bit).

Tip: In the Server box, type the name or IP address of the server. For a named instance, append the instance name to the alias.

Use SQL Server Management Studio or the sqlcmd utility to verify the connection to the new alias.

How To Do SQL Server Native Client Installation?

Your Answer