Learn AWS With MS-SQL(DB) Using SQL Client

0
24

Introduction

In this tip, we will learn about Amazon web service with MS-SQL database using local MS-SQL Management Studio.

SQL Database in AWS

Requirements

  • Register AWS console
  • SQL Server Management Server

Let’s start…

Create SQL Database in AWS

You want to login to the AWS console here. If you have no login, register new users here. After registering, Amazon will provide one year free access. Home page will be loaded like the picture, after login.

SQL Database in AWS

In there, you can select Database >RDS or search in text box as “RDS”.

SQL Database in AWS

The RDS Dashboard page will be loaded, when you click the RDS.

SQL Database in AWS

Now you can create a DB Instance, so click above the button. Then it will show DB Engines.

SQL Database in AWS

Yes, you can see more types of the databases they are providing, so you select MS-SQL Server. They are giving four types of SQL Servers.

  • SQL Server Express
  • SQL Server Web Edition
  • SQL Server Standard Edition
  • SQL Server Enterprise Edition

Free Tier is eligible only in Express Edition, so you can select it.

SQL Database in AWS

You will select default option & database port I have set as “1455”.

SQL Database in AWS

Set backup as your preference & click Launch DB Instance. Success message will show in the next page, as given below:

SQL Database in AWS

Then you can see your database status if you select view Your DB Instance.

SQL Database in AWS

Your database status is “creating” & endpoint isn’t available yet. It will take up to 5 to 10 minutes. Then status changes to “Available” and generates the endpoint.

SQL Database in AWS

Connect to SQL Server Management Studio

If you have SSMS in your PC, open it. Otherwise, you can download it from here.

SQL Database in AWS

Use copy & paste the Endpoint as the Server Name “testsqldb.c7jwysxrximv.ap-south-1.rds.amazonaws.com,1455”. Before the port number changes from “:” to “,” follow the steps fill the user name & password whatever you made it during DB creation & connect.

SQL Database in AWS

I have forgotten to create security group, so please find the menu Compute >EC2>Network & Security.

SQL Database in AWS

In this popup you want add rule and set to the source based on your choice. But I have set anywhere option. Default security group is already there, just update the source.

SQL Database in AWS

Now you can try to connect in SQL Server Management Studio.

SQL Database in AWS

Oh yes, finally, I have connected & created a sample DB & Table.

Conclusion

In this post, we have learned Amazon web service with MS-SQL database using local MS-SQL Management Studio. If you have any queries, please tell me through the comments section because your comments are very valuable.

Happy coding!

LEAVE A REPLY