8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Vm » Here

Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server

This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for SQL Server, a Database as a Service (DBaaS) offering.

Related articles.

Create a New SQL Server Service

Select the RDS option from the service catalog.

ASW Services

Select the "SQL Server EE" option by clicking the "SQL Server" tab and clicking the "Select" button next to the "SQL Server EE" option.

Select Engine

Select the high-availability state of the service. In this case I'm using the non-production option. When you've made your choice, click the "Next Step" button.

Production?

Enter the database details. If you are trialling the service, be careful about the options you pick. If you pick the on-demand license model your service costs will include the SQL Server licensing, making the hourly cost significantly more expensive. Once you are happy with the settings click the "Next Step" button.

Specify DB Details

Enter the advanced settings, making sure the backup and maintenance settings are correct for your service. Once you are happy with the settings click the "Launch DB Instance" button.

Configure Advanced Settings

Click the "View Your DB Instances" button to see the status of your service.

Created

The resulting page shows the status of your services. Once the status is "available", you can connect to the service. If you want to see the monitoring information for the specific service, click the checkbox next to the service and click the "Show Monitoring" button.

Complete

The following picture shows the monitoring graphs.

Monitoring

Connecting to the Service

Open SQL Server Management Studio and connect using the endpoint information from the "Instances" page and the credentials you used while setting up the service.

Management Studio Connection

The instance will appear in the SQL Server Management Studio tree.

Management Studio

You create a new database in the normal way (right-click on "Databases" and select "New Database"), enter the details and click the "OK" button.

Management Studio New DB

The new database is shown in the SQL Server Management Studio tree.

Management Studio New DB Created

For more information see:

Hope this helps. Regards Tim...

Back to the Top.