Create and Connect to a Microsoft SQL Server Database

In this guide, I will explain step by step how you can create a Microsoft SQL Server database Instance (we call this a ‘DB instance’), and how to connect to this DB instance, We will try this tutorial by Amazon Relational Database Service (Amazon RDS)

1. From the Amazon console under database click RDS.

2. On this tutorial, I am going to useAmazon RDS to create a Microsoft SQL Server DB Instance with “db.t2.micro” DB instance class, 20 GigaByte storage, and automated backups enabled with a retention period every day locate the top right corner of “RDS” console, and select your region where you will create the DB instance just like the below screenshot.

3. From the left pane, click Instances. Then click “Launch DB Instance”.

4. As I had mentioned before I am going to create a Microsoft SQL DB so I will select both SQL “Express & SE” just like the below screenshot.

5. It’s time to configure the DB instance. To avoid charges on your account and continue as a free user, make sure to check “Only show options that are eligible for RDS Free Tier”, and enter the configuration just like the below screenshot and then click Next.

6. Now you need to configure the advanced setting on the page like the below screenshot, this configuration is important and RDS needs it to launch the SQL DB instance after you configure it click on “Launch DB Instance”.

7. A confirmation message will appear that confirming that your DB instance is being created after you check click “View your DB Instance”.

8. Go to the Microsoft Download Center – Microsoft SQL Server Management Studio Express page and press on Continue to download a SQL client to be able to connect to the database.

Microsoft SQL

9. Microsoft will prompt to register with it, it’s not required to download, you can skip the registration page and check “No, I do not want to register. Take me to the download” then click Next then select SQL Management Studio, and click Next to start the download.

10. Once your download is done, install the application then run it, and enter the connection details just like the below screenshot.

11. You are now successfully connected to the database, Now you can start creating tables, insert data, and run queries.

Summary

After this tutorial you should be able to know how you can create and connect to a SQL database from Amazon RDS.

Leave a Reply