You are getting the error message below when trying to start the SAP application server. You can capture the error details by running the R3trans -d command and then opening the trans.log file.
ERROR: The ODBC driver [SQL Server Native Client 11.0] is released for server releases (8)-(11), the identified server release is (14). Update the driver. Check note 2656107.
***LOG BY2=> sql error 0 performing CON [dbsh 1289]
Solution
Refer to SAP Note 2656107 – Support for Microsoft ODBC Drivers for SQL Server in SAP NetWeaver.
In our case, we managed to resolve the issue by upgrading to Microsoft ODBC Driver 17 for SQL Server. It can be downloaded directly from the Microsoft Download Center. Depending on the version error shown, you can search for the download files on Google.
