SQL Backup Agent connecting to SQL Server
Published 22 November 2018
You can use SQL Backup Pro to back up SQL server with encrypted connection or using Server Certificate
Encrypted Connection
To do this:
- Open Registry Editor and locate HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(local) or <instance name>
- Create a new DWORD type registry entry called ConnectionEncrypt and set the data value to 1.
- From the Windows Services panel, stop and restart the SQL Backup Agent service.
Connect by trusting the Server Certificate
To do this:
- Open Registry Editor and locate HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(local) or <instance name>
- Create a new DWORD type registry entry called ConnectionTrustServerCertificate and set the data value to 1.
- From the Windows Services panel, stop and restart the SQL Backup Agent service.
To reinstate default connection, set the data value to 0 or delete the ConnectionTrustServerCertificate and ConnectionEncrypt entry.