Agent Jobs

How To Create An SQL Instance In Amazon RDS

How to create an SQL Server Database Instance in Amazon RDS.

Login to AWS: Amazon Web Services

1.

Supply your Amazon AWS Account name, Username, and Password, and click ‘Sign in’.

2.

Select ‘RDS’.

3.

Select ‘Instances’.

4.

Select ‘Launch DB Instance’.

5.

Complete the following actions:

a. Select ‘SQL Server’.

b. Click the ‘Enterprise Edition’ option ( sqlserver-ee ).

6.

For the Dev-Cloud environment select the following options.

a. DB Engine: sqlserver-ee

b. License Model: bring-your-own-license

c. DB Engine Version: 11.00.2100.60.v1 (RTM)

Note: This is pre SP1, SP2, so updates will need to be applied following creation.

d. DB Instance Class: db.m3.medium – 1 vCpu, 3.75

e. Multi-AZ Deployment:

f. Storage Type: General Purpose SSD

There are 3 types of Storage, but ‘General Purpose SSD’ should be sufficient for most standard workloads.

1. General Purpose (SSD): Suitable for a broad range of database workloads. Provides baseline of 3 IOPS/GB and the ability to burst to 3,000 IOPS.

2. Provisioned IOPS (SSD): Suitable for I/O-Intensive database workloads. Provides flexibility to provision I/O ranging form 1,000 to 30,000 IOPS.

3. Magnetic Storage: Used for small database workloads where data is accessed less frequently.

Note:

Make sure to select the Storage type that best fits your database environment. The storage type CANNOT be changed once the instance is created. ‘Scaling Storage’ is not supported for SQL Server in Amazon RDS.

g. Allocated Storage*:

Note1:

If you are selecting storage greator than 20 GB, this will disqualify the instance from being supported on the ‘free tier’.

Note2:

If you select a medium storage type; you must select a VPC on the following Step3 Configure Advanced Settings. Storage is dependent on the VPC.

h. DB Instance Identifier: MyInstanceName

Note: Instance Name must be under 15 characters.

i. Master Username: MySaUserName

Note: This represents the ‘sa’ account in SQL Server.

j. Master Password: MyNewPassword

k. Confirm Password: MyNewPassword

Click ‘Next Step’ after the correct selections have been made.

7.

Click ‘Launch DB Instance’.

8.

The Wizard will proceed to create the instance at this point. No more selections need to be made.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s