How to Resolve SQL Server Instance Not Listing Issue

How to Resolve SQL Server Instance Not Listing Issue

KB ID: 115912
Cause:
The SQL Server instance might not be listed due to insufficient permissions during the installation of the BDRSuite Client Files Application, preventing access to SQL server entries in the system registry.
Resolution Steps
1. Change Service Logon Account:
  1. Change the `BDRSuite_Client_Files_Application` service logon account to an Administrative account from the Local System Account.
2. Ensure Necessary Plugin Files Are Present:
  1. This issue may occur if the necessary plugin files are missing from the installation location. It is  due to insufficient permissions for BDRSuite_Client_Files_Application to access SQL Server entries in the system registry.
  2. To resolve this,
    1. Download the files `AdvMSSQLServer.sgpl` and `MSSQLServer.sgpl` 
    2. Move these files to the following location:
      C:\Program Files\Vembu\VembuNetworkBackup\plugins
  1.  Once the files are placed, restart the "BDRSuite_Client_Files_Application" service.
3. List the SQL Server Instance:
  1. Try to list the SQL server instance again.
  2. If you still face issues, contact BDRSuite Support
Conclusion
By changing the service logon account to an administrative account and ensuring the necessary files are in place, you can resolve the issue and list the SQL Server instance successfully.

    • Related Articles

    • Error: Unable to Connect to SharePoint Server Farm Due to SQL Server Permissions Issue

      KB ID: 82 Issue: When attempting to connect to the SharePoint server farm via the Portal Site http://svsweb2:9999, an error occurs. The specific error message states: "This operation can be performed only on a computer that is joined to a server farm ...

    • Unable to List Databases during Microsoft SQL Server Backup

      KB ID: 110000 Case 1: Microsoft SQL Server services are not running properly. Problem: This error occurs when the system is unable to list databases. This issue may arise if the SQL Server service and its associated services are not running. ...

    • Troubleshooting: Getting an empty database list or database are not listing while creating SQL server backup

      KB ID: 115908 Cause: The occurrence of an empty database list is often attributed to the user authenticated to the SQL instance lacking the necessary permissions. Solution: To address this issue, follow these steps to ensure the user has appropriate ...

    • Microsoft SQL Server Recovery

      Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...

    • Microsoft SQL Server Recovery

      Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...