How to create an SQL Server Database Instance in Amazon RDS.
Login to AWS: Amazon Web Services
Supply your Amazon AWS Account name, Username, and Password, and click ‘Sign in’.
Select ‘Launch DB Instance’.
Complete the following actions:
a. Select ‘SQL Server’.
b. Click the ‘Enterprise Edition’ option ( sqlserver-ee ).
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.
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*:
If you are selecting storage greator than 20 GB, this will disqualify the instance from being supported on the ‘free tier’.
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.
Click ‘Launch DB Instance’.
The Wizard will proceed to create the instance at this point. No more selections need to be made.
Categories: Agent Jobs, Alerts, Automations, Backup & Restore, Command Prompt, Database Mail, Database Mirroring, ELI5, Error Solutions, Featured, Folder System, Forensics & Auditing, High Availability, Long Scripts, Management Studio, Notification, Powershell, Quick Fix, Scripts, Security, Short Scripts, SQL Stuff, TSQL, Work Arounds