Dears,
We are making an HA pair of Config Server in where one server is Windows Server 2012 and the other is Linux Centos but we are trying to start the Config Server Backup this server does not initialize correctly in the logs of the config server backup with the issue we found this message below:
15:29:50.989 Trc 04524 Client 'DbServerThread_app' disconnected15:29:50.991 Std 07002 Execution failure: SQL statement '?', reason '[unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found ', error code 3015:29:50.991 dbserver_manager with alias main-dbserver is about to unregister form socket 8, reference counter 3 (reason - exception)15:29:50.991 Std 04502 Cannot connect to Database 'config' at host 'agustinlab\agustinlab', port -1, reason 'Server not found'15:30:00.992 dbserver_manager with alias main-dbserver has being registered for the socket 8, reference counter 315:30:00.992 Trc 04500 Connecting to Database 'config' at host 'agustinlab\agustinlab', port -115:30:00.997 Std 05022 Process './dbclient_msql_64' started'./dbclient_msql_64' registered; protocol version '1.4' id '3.1'ODBC: id='3.1' req='-1'DBClient ODBC, 2018All Rights ReservedDb Client version: 8.5.101.18DB Common part version: 8.5.101.18Vendor supported versions: "13.0"Process ID: 25453Build on 'i686-linux-rhe6.5' +0000 Connection to multiserver created, host 'localhost', port '35637', socket '4'ODBC: id='3.1' req='1' Protocols versions: dbclient='00010004' dbserver='00010004' dblib='00010004' +0000 Database Access Point in TKVList: +0000 section "default": +0000 "dbengine" = "mssql" +0000 "dbserver" = "agustinlab\agustinlab" +0000 "dbname" = "config" +0000 "username" = "sa" +0000 "password" = "***" +0000 section "dbclient": +0000 "max-binding-memory" = 250 +0000 "utf8-ucs2" = "false" +0000 0x1ca36a0,hDBC=30033424,30033424 +0000 Could not connect to SQL Server using SQL Native Client. Attemting default MS SQL Server driver... +0000 odbcerr: [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not foundThis is our architecture:Config Server Primary is running in Windows Server2012
Config Server Backup is running in Centos
Versions of the Config Server is this:8.5.101.41
Dbserver 8.1.302.09 is running in Windows
DBMS: Microsoft SQL server MSSQL14
We would like to know if its possible to create an HA environment between linux and Microsoft or its possible What can be missing in this environment to work?
Thank you very much for your help
#ArchitectureandDesign------------------------------
Edwin Moreno
Interaxa S.A.
------------------------------