Skip to main content
Barracuda MSP Partner Toolkit

No SQL Servers Appear During Backup Set Creation

When trying to create a SQL backup set, you click on the Discover button to populate a list of SQL servers present but none appear.  Alternatively, a SQL server is populated but it is not the one you are trying to back up.

 

Explanation


When setting up a SQL backup set, sometimes the Backup Agent fails to locate SQL instances on the server it is installed on.  This may be due to permission issues or other factors, but it can usually be fixed by entering the SQL server address manually or running the Backup Agent service as a SQL administrator.

 

Resolution


First, try running the Backup Agent service as a SQL administrator.  If this does not fix the issue, you will need to enter the SQL server address manually.  To do this, the address will need to take the form HOST\SQLSERVER.  For instance, if the server where the SQL server is installed is called "Server01" and the SQL server is called "MSSQLSERVER" then the address will be Server01\MSSQLSERVER.

  • Was this article helpful?