Requirements for Microsoft SQL Server

To register Microsoft SQL Server sources, ensure you meet the version and permission requirements, then download and install the Cohesity Agent.

Before you register your Microsoft SQL Server source, ensure that you have the supported Microsoft SQL Server deployments. For more information, see Supported Software for DataProtect as a Service.

Also, make sure you meet the minimum permissions below and then install the Cohesity Agent on each SQL server you wish to protect.

Minimum Permissions

To be able to register a Microsoft SQL Server source, you need to first install the Cohesity Agent on that source. To install the Cohesity Agent, you can use either the LOCAL SYSTEM account or an account that:

  • Is a member of the local Windows Administrators group. For example, if qa01\tme-backup is an Active Directory user account in the data center that the backup admin plans to use, qa01\tme-backup must be part of the local Windows Administrators group on the SQL server.

  • Has Log on as a service in the User Rights Assignment on the Microsoft SQL Server to install the CohesityAgent.

  • Has the sysadmin role in the Microsoft SQL Server instance for transaction (T-log) log backup requirements. The sysadmin role is a Microsoft requirement that allows third-party solutions to back up transaction logs (T-logs) for full and bulk-logged recovery model databases.

Check Firewall Ports

Ensure that the ports listed in the Microsoft SQL Servers section in the Firewall Ports for User-Deployed SaaS Connectors topic are open to allow communication between the Cohesity SaaS Connector(s) and Microsoft SQL Server.

Considerations

  • Windows 2008 R2 Operating System is not supported for SQL Server protection on Cohesity DataProtect as a Service.

Download and Install the Agent

Install the Cohesity Agent on each SQL server that you want to protect.

To install the Cohesity Agent:

  1. In DataProtect as a Service, navigate to Sources and select Register Source > Microsoft SQL Server.

  2. At the bottom of the Register a Microsoft SQL Server dialog, click Download Cohesity Agent. Make sure you download the Agent on the server you plan to protect.

  3. As an administrator with local system privileges on that server, run the executable and complete the installation wizard.

  4. Service Account Credentials. Enter either the LOCAL SYSTEM account credentials or an account that meets the minimum permissions above.

  5. Wait for the Agent installation to finish. In SQL Server Management Studio (SSMS), validate that the account used to install the Cohesity Agent has SQL Server Role: sysadmin in the SQL server instances.

  6. The Agent starts automatically.

Repeat the Agent installation process on each SQL server you want to protect. This includes any standalone Microsoft SQL Servers and Microsoft SQL Server nodes with AGs.

Next > Register your Microsoft SQL Server source to protect your databases!