#Enable SQL Server Authentication

Follow the steps below to enable SQL Server authentication for your self-managed SQL Server:

1. Follow steps in Change server authentication mode to enable SQL Server authentication.

2. Create a user and grant the sysadmin permission to the newly created user. Below are example scripts for how to create user and grant permission. Replace ‘username’ in the command with the actual name of the user you created.

   CREATE LOGIN username WITH password='**';    
   
   CREATE USER username FOR LOGIN username 
   
   WITH DEFAULT_SCHEMA = master;
   
   GO
   
   ALTER SERVER ROLE [sysadmin] add member username;
   
   GO

3. Navigate to Cloud Backup for IaaS + PaaS, then go to Settings > CAP Gateways page to verify that the configured CAP Gateway server can successfully connect to your registered SQL Server instance. Once the connection is confirmed, the backup service is enabled.