Troubleshooting Error 231002: SQL Server Not Installed on Target Host

KB ID: 231002

Case 1: SQL Server is not installed on the target host.

Problem:
This error occurs when attempting a backup operation on a target host without SQL Server installed.
Solution:
To resolve this error, ensure that SQL Server is installed on the target host. After installing SQL Server, proceed with BDS installation or backup operations as needed.

Case 2: BDS Agent installed on the target host before SQL Server installation.

Problem:
Error 231002 also occurs when the BDS Agent is installed on the target host before installing the SQL Server, leading to issues during backup operations.
Solution:
To resolve this error in this scenario, follow these steps to reinstall the BDS Agent:
1. Locate the BDS Agent Installer: Obtain the BDS Agent installation package or installer. Download it from the BDRShield backup server or your organization's repository if needed.
2. Run the BDS Agent Installer: Execute the BDS Agent installation package on the target host.
3. Reinstallation Process: During installation, choose to reinstall or repair the BDS Agent based on available options in the installer.
4. Follow Installation Wizard: Adhere to the instructions provided by the installation wizard. It should guide you through the reinstallation process without requiring uninstallation of the existing agent.
5. Complete the Reinstallation: Allow the installer to finish the reinstallation of the BDS Agent and confirm that the agent is successfully reinstalled.
6. Verify Functionality: Ensure that the BDS Agent is functioning correctly.
7. Proceed with Backup: After successfully reinstalling the BDS Agent, proceed with backup operations

Following these steps should enable you to resolve the error in situations where SQL Server is not installed or when the BDS Agent was installed before SQL Server on the target host.