Thanks for the reply, Steve.
You’re correct, the C:\Windows\System32\config\systemprofile\AppData\Local\BigFix\BESAdminDebugOut.txt logfile has good information in it:
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – Admin tool version 9.5.10.79
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – Lang option specified:
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – Entering CBFEAdminApp::DoPreUpgrade…
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – Check buffer directory.
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – Check Non ASCII Site Files
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘user’. (28000: 18,456)
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – There was an error connecting to the database. Check that you have sufficient database privileges:
Database Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘user’. (28000: 18,456)
Fri, 08 Mar 2019 08:08:59 -0600 – 6160 – Exit Admin Tool …
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – Admin tool version 9.5.11.191
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – Lang option specified:
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – Entering CBFEAdminApp::DoPreUpgrade…
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – Check buffer directory.
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – Check Non ASCII Site Files
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘user’. (28000: 18,456)
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – There was an error connecting to the database. Check that you have sufficient database privileges:
Database Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘user’. (28000: 18,456)
Fri, 08 Mar 2019 08:27:34 -0600 – 5640 – Exit Admin Tool …
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – Admin tool version 9.5.11.191
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – Lang option specified:
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – Entering CBFEAdminApp::DoPreUpgrade…
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – Check buffer directory.
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – Check Non ASCII Site Files
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘sa’. (28000: 18,456)
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – There was an error connecting to the database. Check that you have sufficient database privileges:
Database Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘sa’. (28000: 18,456)
Fri, 08 Mar 2019 08:45:05 -0600 – 13452 – Exit Admin Tool …
I also worked with Support and we came to the conclusion that this issue needs to be escalated to Engineering. We verified I am using a valid login and password which has access to the database, however, the Fixlet is unable to connect to the database with the credentials I supply. When I provide the svc account to the Fixlet, it should make a connection to the database. The database is remote and that may be causing the issue. When I do not provide any credentials to the Fixlet, it defaults to ‘sa’ which I do not have the password and I know it’s not the default password, therefore I understand why the Fixlet fails without credentials.
When I get information back from support, I’ll provide an update to this thread.
Thanks again!