When you seek help from Alibaba Cloud technical support to locate problems that occurred
on your ApsaraDB RDS for SQL Server instance, you may need to grant permissions to
the service account of your RDS instance. The service account is used by Alibaba Cloud
technical support to perform operations on the databases of your RDS instance. After
the specified expiration time elapses, ApsaraDB RDS deletes the service account.
Prerequisites
Your RDS instance runs SQL Server 2008 R2 with local SSDs.
Procedure
- Visit the RDS instance list, select a region above, and click the target instance ID.
- In the left-side navigation pane, click Accounts
- On the Service Account Permissions tab, find the permission that you want to grant to the service account, and turn
on the switch in the Permission Status column.
- For problems that are related to IP address whitelists or database parameters, you
can grant only the Configuration Permission to the service account.
- For database performance problems that are caused by applications, you must grant
the Data Permission to the service account.

- In the dialog box that appears, specify the expiration time of the service account
and click OK.
What to do next
After you grant permissions to the service account, you can revoke the permissions
or change the expiration time on the Service Account Permissions tab at any time.