AWS managed policies for Microsoft SQL Server on Amazon EC2

To add permissions to users, groups, and roles, it is easier to use AWS 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 AWS managed policies. These policies cover common use cases and are available in your AWS account. For more information about AWS managed policies, see AWS managed policies in the IAM User Guide.

AWS services maintain and update AWS managed policies. You can't change the permissions in AWS managed policies. Services occasionally add additional permissions to an AWS 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 AWS managed policy when a new feature is launched or when new operations become available. Services do not remove permissions from an AWS managed policy, so policy updates won't break your existing permissions.

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

AWS 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 AWS 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 AWS Managed Policy Reference.

AWS 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 AWS Managed Policy Reference.

AWS managed policy: AWSEC2VssRestorePolicy

You can attach this managed policy to the IAM role that's used to execute the AWSEC2-RestoreSqlServerDatabaseWithVss automation runbook. The policy grants permissions to create volumes from VSS snapshots, attach them to instances, and invoke AWS Systems Manager Run Command documents required for database restoration.

Permissions details

This policy includes the following permissions:

To view the permissions for this policy, see AWSEC2VssRestorePolicy in the AWS Managed Policy Reference.

SQL Server on EC2 updates to AWS managed policies

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