Creating and connecting to SQL Server in AWS RDS

Posted on by

Amazon Web Services (AWS) offers Relational Database Service (RDS) with the following RDMSs. 

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Oracle

In order to create a AWS Managed RDS click on the RDS link in the management console under the Database section.

image This will lead to the following screen, and here you can begin creating a SQL Server in AWS managed RDS.

image

Fill the below details.

image

In the above form I selected micro instance as it gets qualified for the free tier service,  and Multi-AZ Deployment is disabled. Multi-AZ Deployment helps you to scale up the instances and works as a failover mechanism. Scaling the storage after the database engine has been provisioned is not supported by the SQL Server in AWS. Note that scaling the instances and scaling the storage are two different things.

image

After filling the details you can launch the DB Instance. You will see the following information about the DB instance you created.

image

 

Connecting to AWS SQL Server from SSMS

Notice that in this instance SQL Server is running in its default port. In order to connect to the DB Instance from any client tool like SSMS you have to enable the inbound rule for the security group in which your DB instance lives. In order to perform this action quickly from the above screen click on the exclamation mark icon beside the underlined section.

image

 

In this case I put the DB instance in the default security group. Click on the default link and it will take you to the Networks and Security section.  Click the Inbound tab, select Edit and configure the SQL Server port and assign IP rule. (You have the options to select a specific IP, or your current IP and All IP). In this example I added the rule connect from anywhere (All IPs). But mostly for your production server you will not do this.

image

Save the settings for the security group.

Now the inbound port TCP:1433 is enabled and you can connect from the SSMS. Copy the underlined endpoint name of the server without the port number, that is your SQL Server name.

image

Enter the password and you will be connected to the DB Instance.

image

Advertisement