Recently I became involved in a project to rollout the MOVE product, through ePO. As part of our internal proof of concept, we stood up an ePO server, but the user who performed that work is no longer with us.
When that user's account was deleted, DB authentication began to fail, and ePO stopped working. I have been able to regain control of the database, I can issue queries against the ePO tables successfully, etc, when connected to the DB through Management Studio. However, when I attempt to use the ePO config page:
everything appears ok. I enter credentials, they are saved, they are the same ones I am using in Management studio, but the connection is failing. Using the Test Connection button on the config screen results in an odd error:
Test failed: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
The user is blank, though I have info added and showing in the proper fields. I have restarted the server, with no luck. Checking the logs that are written to %installdir%\McAfee\ePolicy Orchestrator\DB\Logs show that the right user appears to be getting sent to SQL:
20120504170523 I #02276 NAIMSRV Initializing server...
20120504170523 I #02276 NAIMSRV Database initialization: Starting.
20120504170523 W #02276 EPODAL DAL2_CConnection::Init: Login for MyDbUser failed. Building profile and retrying.
20120504170523 E #02276 PONTUTIL Failed to create local ePO User Group, push agent aborted! System error code 1379
20120504170523 E #02276 EPODAL DAL2_CConnection::Init: Failed to logon the domain user MyDbUser to connect to database.
20120504170523 E #02276 EPODAL DAL2_CConnection::Init: Error 0x80070002 returned from credentials callback. Database NOT available
When I check the SQL logs to see what is happening on that side, I note that no user appears to be passed to SQL at all:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 127.0.0.1]
Anyone have ideas as to what I am doing wrong? My user setup is exactly the same as the one I am replacing, and I am not seeing the old credentials in logs anymore, but I am still not having any luck breathing life back into the server. We are running ePO 4.6.1 with the SQL Express 2005 option.
A DBA I am not, for sure, so any help or suggestions would be greatly appreciated!