(imported topic written by SystemAdmin)
Hi, second problem of the day (although this one has been happening for a long time),
We currently have a setup where the BES server is not located on the same server as the SQL database. This was running fine, but now we have a major problem that when the SQL server or the BES server is rebooted, noone can log onto the BigFix console and more importantly, no relays communicate with the server (or at least the information is not getting inputted from the server to the DB)
In ODBC it is currently set to use SQL Authentication to connect to the DB and this used to work fine. Now we have to force it to use NT Authentication to get the relays/server to communicate with the SQL server. Once they have communicated, we can then switch it back to SQL Authentication and our operators can log back in.
Does anyone know why this would happen?
Many thanks
Edit: We sometimes have to run a dos command to restart all of the BES relay services to kick start things into action.