Application server for CRM has SQL native client 2008 version installed. I have installed SQL native client 2012 side by side as need to connect to an sql availability group listener. How do I get the application server to use the new client version? Oledb connection
Thanks
Sql-server – SQL Native Client Upgrade
connectivitynative-clientsql serversql-server-2008-r2sql-server-2012
Related Question
- SQL Server Network – SQL Native Client and Network Disconnects
- SQL Server – Where to Find the Installer for SQL Server Native Client 11.0.5058
- SQL Server 2012 – Compatibility Level 110 and SQL Server Native Client 10
- Sql-server – the latest version of SQL Server native client that is compatible with Sql Server 2008 r2
- Sql-server – SQL Native Client 11 – SQL Server 2017
- Sql-server – Where to find the installer for SQL Server Native Client 11.0.7462
- Sql-server – SQL native client installation
Best Answer
The OLE DB provider is usually specified via a connection string for database applications. Connection strings are usually stored in an external application configuration file so that the driver and other attributes (server, database, etc.) can be changed without code changes. Below is are SQL Server 2008 and 2012 Native Client examples, with SQLNCLI11 being the 2012 version:
Applications can also configure connection string properties programmatically or even have values hard-coded. Consult your CRM vendor documentation to determine specifics of configuration file locations or other configuration means, and importantly, verify the software supports SQL Server 2012 native client.