Problem description
After installing the Phoenix SQL agent on the server, the SQL database is not visible on the Phoenix Management Console.
Cause
This problem occurs if the logon account under which the Phoenix service is running does not have login enabled in SQL Server Management Studio (SSMS).
Traceback
Navigate to the
C:\ProgramData\Phoenixlocation.Open the
main_service.logfile.
[2020-08-26 11:35:52,434] [DEBUG] SqlClusterHelper : instances = [u'<SQL_instance_name>'], command_params={}
[2020-08-26 11:35:52,497] [ERROR] Error[('28000', u"[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<>'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<>'. (18456)")] while connecting with instance [SQL_instance_name] using SQL Server driver
Resolution
Enable login for the Phoenix Service account using SQL Server Management Studio.
Steps
Log in to the SQL Server Management Studio with an account whose login is enabled.
Expand the Security and click Logins.
Right-click on the service account name and click Properties.
Click on the Status button and in the Login section click Enabled.
Restart the Phoenix agent service.
Verification
Trigger the backup which should now complete successfully.