How To Do SQL Server Native Client Installation?
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?
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.