Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon managed policies for Amazon EC2 High Availability for SQL Server

To add permissions to users, groups, and roles, it is easier to use Amazon managed policies than to write policies yourself. It takes time and expertise to create IAM customer managed policies that provide your team with only the permissions they need. To get started quickly, you can use our Amazon managed policies. These policies cover common use cases and are available in your Amazon account. For more information about Amazon managed policies, see Amazon managed policies in the IAM User Guide.

Amazon services maintain and update Amazon managed policies. You can't change the permissions in Amazon managed policies. Services occasionally add additional permissions to an Amazon managed policy to support new features. This type of update affects all identities (users, groups, and roles) where the policy is attached. Services are most likely to update an Amazon managed policy when a new feature is launched or when new operations become available. Services do not remove permissions from an Amazon managed policy, so policy updates won't break your existing permissions.

Additionally, Amazon supports managed policies for job functions that span multiple services. For example, the ReadOnlyAccess Amazon managed policy provides read-only access to all Amazon services and resources. When a service launches a new feature, Amazon adds read-only permissions for new operations and resources. For a list and descriptions of job function policies, see Amazon managed policies for job functions in the IAM User Guide.

Amazon managed policy: AWSEC2SqlHaInstancePolicy

You can attach this managed policy to the IAM role that's attached to your Amazon EC2 High Availability for SQL Server instance. The policy grants permissions to execute Amazon owned Systems Manager command document AWSEC2-DetectSqlHaState to the instance, to retrieve the EC2 SQL HA instance metadata and decide whether it's in active or standby state.

To view the permissions for this policy, see AWSEC2SqlHaInstancePolicy in the Amazon Managed Policy Reference.

Amazon managed policy: AWSEC2SqlHaServiceRolePolicy

This policy is attached to the service-linked role named AWSServiceRoleForEC2SqlHa to allow Amazon EC2 High Availability for SQL Server on EC2 to detect whether an EC2 instance that's tagged with the EC2 SQL High Availability identifier (SqlHaMonitored set to true) is running in active or standby mode.

To view the permissions for this policy, see AWSEC2SqlHaServiceRolePolicy in the Amazon Managed Policy Reference.

SQL Server on EC2 updates to Amazon managed policies

View details about updates to Amazon managed policies for SQL Server on EC2 since this service began tracking these changes.