Step 2 (RDS): Setup Amazon RDS Microsoft SQL Server

This guide is about how to setup a Microsoft SQL Server database instance in Amazon Relational Database Service (RDS).

How to setup Amazon RDS MS SQL Server?

Go to your AWS account

If you have an account in AWS, you can log in here (You may setup a new one too).

1. After your log in to AWS, click the Services dropdown on your left-side.

2. Click on RDS.

3. Select Region from the drop-down on your right.


4. Then, click on Instances on the sidebar on your left.

5. Click Launch DB Instance in the main window.

6. On Step 1 (Select Engine), from the list of Engines that appear, click on the Microsoft SQL Server icon. In the next screen you will see the SQL Server editions that are available. Choose the one you want and click on Select.

AWS RDS MS SQL Server Setup

7. On Step 2 at the Production? page asks if you are planning to use the DB instance you are creating for production or Test.

For Production you may choose the failover option Multi-AZ and the Provisioned IOPS storage option. Click Next Step when you are finished.

8. At Step 3 you will need to Specify DB Details.

AWS RDS MS SQL Server Setup

Instance Specifications:
License Model: Select license-included to use the general license agreement for Microsoft SQL Server. Select bring-your-own-license to use your existing license
DB Engine Version: Select the version of Microsoft SQL Server you want to use.
DB Instance Class: Selects the instance (machine) your Microsoft SQL Server  instance database will run on.
Time Zone: Choose a time zone for your DB instance.
Multi-AZ Deployment: Select Yes to have a standby backup machine in a different Availability Zone than your the DB instance.
Storage Type: Specify the storage disk type you’d like to use.
Allocated Storage: Allocate storage for your database.

If you need more detailed setup see the relevant AWS Guide.

Database settings:
DB Instance Identifier: Choose a unique identifier for the database that must be unique for your AWS account in the current region.
Master Username: A username you will use to log in to your instance.
Master Password: Your password 🙂

9. At Step 4 you will need to Configure the Advanced Settings.

Network & Security:
VPC: The Virtual Private Cloud you want your server to be. If you have a VPC setup select it. If not, select Create New VPC.
Subnet Group: The subnets that the DB instances can use in the VPC. If you have a DB Subnet Group setup select it. If not, select Create new DB Subnet Group.
Publicly Accessible: Select Yes to give the DB instance a public IP address, meaning that it will be accessible outside the VPC.
Availability Zone: Select the availability zone you want for your instance. Else leave it on the default No Preference.
VPC Security Groups: The traffic rules concerning the traffic from / to your instances. If you have a VPC security group select it. If not, select the default VPC.

AWS RDS MS SQL Server Setup

Database Options:
Database Port: The port you want to use to access the database. MS SQL Server default is port 1433.
DB Parameter Group: A configuration applied to the database. If you haven’t created one then choose the default.
Option Group: More options of the database. Use the default value unless you have created your own option group.
Copy Tags To Snapshots: check if you want the tags metadata on DB instances copied to corresponding instance snapshots.
Enable Encryption: Specify if you want the database and snapshots to be encrypted.

Backup Retention Period: Set the number of days you want automatic backups of your database to be retained. Always keep on mind on the cost that this may incurr.
Backup Window: Select the time of day you’d like you backup to happen.

Enable Enhanced Monitoring: Select to enable gathering metrics in real time for the operating system that your DB instance runs on.

Auto Minor Version Upgrade: Select to enable your DB instance to receive minor DB engine version upgrades automatically when they become available.
Maintenance Window: Select a 30 minute time window that you prefer updates and other maintenance to happen. If time period doesn’t matter, select No Preference.

10. When you’re finished with the setup, click Launch DB Instance. On the final page of the wizard, click View Your DB Instances.

11. On the Amazon RDS console, at Instances tab you should see the new DB instance appears in the list. When its status is Available then it is ready for use.

AWS RDS MS SQL Server Setup

Next Steps:

Blendo needs to connect to the database to send the data. In order to do this, you must edit the security group permissions.

READ NEXT: Step 3: Permissioning Blendo to Amazon RDS


Questions? Contact us!

in MS SQL Server