Hi all !
I’m moving the databases from a local sql server(installed with BF with Windows Authentication) to a remote sql server 2014 with SQL authentication.
I changed the ODBC DSNs and tested them with success (with 2 accounts : the ‘sa’ and a sql user account).
I changed BF keys in Windows registry (UseRemoteDb=1, Database/user and password).
I restarted ‘BES Root Server’ service.
So, when I’m opening the Console BigFix, I write my credential but that failed with the message ‘Unable to login to server’.
and I have these messages in the BESRelay.log :
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - BES Root Server version 9.5.9.62 built for WINVER 6.0 x86_64 running on WINVER 6.3.9600 i386, starting
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - OpenSSL Initialized (Non-FIPS Mode)
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - Using OpenSSL crypto library libBEScrypto64 - OpenSSL 1.0.2j 26 Sep 2016
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - Startup failed: error testing database connection: Database Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (IM002: 0)
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - Will retry in 5 seconds
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - Startup failed: error testing database connection: Database Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (IM002: 0)
Thu, 08 Apr 2021 10:01:01 +0200 - Main Thread (1164) - Will retry in 5 seconds
I tested to revert to the local DB and all work fine !
Did I miss something ?