Skip to main content


 

 

druva_logo.pngDruva
|
Documentation

How can we help you?

Trending articles:

 

Druva Documentation

Unable to discover the SQL Database

  1. Last updated
  2. Save as PDF
Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

 

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

  1. Navigate to the C:\ProgramData\Phoenix location.
  2. Open the main_service.log file.

[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 '<Name of the service account>'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<Name of the service account>'. (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

  1. Log in to the SQL Server Management Studio with an account whose login is enabled.
  2. Expand the Security and click Logins.
  3. Right-click on the service account name and click Properties.
  4. Click on the Status button and in the Login section click Enabled.
  5. Restart the Phoenix agent service.

SQL login.PNG

Verification

Trigger the backup which should now complete successfully.