Can I run the E-Tech CloudBAK client on a different computer from the MS SQL server that I want to backup?
For LAN SQL backups, please verify the following:
1) If it is a scheduled backup, make sure the backup has a username/password specified. Otherwise the Backup Scheduler will use the local system account which does not have access to network resources.
2 i) If the SQL server is on the same domain as your backup client, then you should configure your backup client schedule to use a domain username/password.
2 ii) If the SQL server is not on the same domain as your backup client, then you need to use a schedule username and password that exists on both the backup client computer and the SQL computer.
3) Your MS SQL service should be configured to use the same username and password as mentioned in step 2. (i.e. it cannot run from the local system account for the same reason as mentioned in step 1. I.e. The local system account cannot access network resources).
Typical service name for MS SQL Full: MSSQLServer
Posted in: Backing Up MySQL