Before you use Cloud Backup to back up an SQL Server database deployed on an Elastic Compute Service (ECS) instance or on-premises server, you must create a backup account, grant permissions to the backup account, and configure the network.
Step 1: Obtain the username and password
Install Cloud Assistant Agent on the ECS instance that hosts the database. This step is required if the database that you want to back up is deployed on an ECS instance.
A Cloud Backup client for ECS must be used together with Cloud Assistant.
If you purchased the ECS instance before December 1, 2017, you must manually install Cloud Assistant Agent. For more information, see Install Cloud Assistant Agent.
If you purchased the ECS instance on or after December 1, 2017, Cloud Assistant Agent is pre-installed.
Obtain the username and password of the SQL Server database.
Step 2: Create a backup account and configure permissions
Use SQL Server Management Studio (SSMS) to log on to the SQL Server database.
For more information, see Download SSMS.
Change the database recovery model to Full.
If you do not change the database recovery model to Full, you cannot back up database logs.
Right-click the database and select Properties.
On the Options page, set Recovery model to Full and click OK.
Create an SQL Server user.
Create a login in SSMS.
Enter the username to backupadmin, select SQL Server authentication, and enter the password.
Do not select User must change password at next login.
On the Server Roles page, assign the sysadmin and dbcreator roles to the account.
On the User Mapping page, select the database that you want to back up, select the db_backupoperator and db_owner database role memberships, and then click OK.
Enable SQL Server and Windows authentication mode.
Right-click the server object and click Properties.
Go to the Security page, select SQL Server and Windows Authentication mode and click OK.
Step 3: Configure network settings
Log on to the server where the SQL Server database resides.
Enable the TCP/IP protocol in the SQL Server network configuration.
Open SQL Server Configuration Manager.
In the left-side navigation pane, choose SQL Server Network Configuration > Protocols for MSSQLSERVER. Then, right-click the TCP/IP protocol and choose Enable.
Restart the SQL Server server.
What to do next
Register an ECS-hosted SQL Server database or Register an on-premises SQL Server database