The problem with the connection to the Microsoft SQL server, when creating a backup project, is usually result from an incorrectly entered server name.
The Xopero system detects only host name, on which at least one MS SQL server instance is located, but we must remember that there may be many instances on one host.
That's why instance name must be included in backupset, the full server name should be:
HOST_NAME\INSTANCE_NAME , for example:
If we don't know the name of an instance, we can find it by few ways:
1. Sql Server Configuration Manager
After running the above-mentioned tool, go to the SQL Server Services window and look at the name in brackets next to the SQL Server entry:
2. Microsoft SQL Server Management Studio
One of the basic tools that also allows us to verify the instance name already on the server connection window:
In case you log in automatically, the name can be verified in the Object Explorer.