Saturday, November 14, 2015

The provider 'SQLNCLI11' is not registered.


To solve this issue install the SQL Native Client:

Download: http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

Part of the Microsoft SQL Server Feature Pack, a useful component that is very important for applications that are designed to connect with Server 2012 is Microsoft SQL Server 2012 Native Client.

This dynamic-link library (DLL) brings support for integrating the latest capabilities of SQL Server 2012 into the software that have it embedded in their code. Thus, the SQL ODBC driver, as well as the SQL OLE DB provider become available when Microsoft SQL Server 2012 Native Client is part of the equation.

Running the installer for this library will add to the target system the client components that are required for SQL Server 2012 connectivity. Also part of the package are the header files that programmers can use when creating utilities that employ SQL Server Native Client application programming interface (API).

With Microsoft SQL Server 2012 Native Client installed, when trying to establish a connection with the server the user will be prompted to specify the data source name and description, as well as specify the instance of SQL Server on the network.

Specifying the authentication method, configuring the advanced client entries and the login details that will be used by the Native Client ODBC drive to establish the connection are also required. The following step is to set the default database for the data source and there are also some other options like the language for the SQL Server messages or the usage of regional settings.

In case the details are not filled in full, the Microsoft SQL Server Native Client ODBC driver or the SQL Server Native Client OLE DB provider will bring up the SQL Server Login box where the necessary information can be specified.