This guide explains the settings required to use an remote SQL Server installed on Ubunu 18.04.
The Guide does assume the following:
Microsoft ODBC Driver for SQL Server is installed on SolidCP Server ( https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server )
For ubuntu you will need to make sure you install cifs-utils by running:
apt-get install cifs-utils
File: /etc/fstab
//SCPServer/SQLBackupTmp /mnt/sqlbackuptmp cifs username=SQLBackupTmp,password=password,uid=mssql,_netdev,x-systemd.automount 0 0
Databases Location: This is the local location the databases are usually found (The default is /var/opt/mssql/data/).
Backup Options:
SolidCP Server backup path: This is the Windows location of the share you have created.
Network path or linux mount point: This is the mount point you have set in the fstab.