Troubleshooting Error 231002: SQL Server Not Installed on Target Host

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 BDRSuite 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.

    • Related Articles

    • Troubleshooting Network Path Connection Issues to Target Host

      KB ID: 117037 Issue: Encountering difficulties when trying to establish a network path connection to the target host with BDRSuite Cause: This problem occurs when the BDRSuite Backup Server or BDRSuite Backup Client cannot access the admin$ share ...

    • Unable to Connect to the Target Host

      KB ID: 117068 Cause: This error can occur due to the following reasons: 1. The target host's IP address is not reachable. 2. The Vembu Integration Service (VIS) is not available or not running on the target host. Solution: Cause 1: Ensure the ...

    • Error: Host Already Added in Backup Server - Troubleshooting Guide

      KB ID: 117001 Cause: The error occurs "This host is already added in the backup server" when you are trying to add a host with the same target hostname or IP address that is already present in the user interface (UI). Solution: 1. If you encounter ...

    • Add MS SQL Server

      MS SQL Server can be backed up using the BDRSuite Backup Server. You can simply add the MS SQL Host as a Data Source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add MS SQL Server. When a MS SQL Server ...

    • Unable to Connect to Target Host: Network Connection Issue Troubleshooting

      KB ID: 117043 Cause: Encountering connectivity issues when attempting to connect to the target host may result from the following scenarios: Cause 1: Unreachable Target Host (UNC Validation) The target host is not reachable, leading to issues with ...