AvoidErrors
  • HOME
  • WINDOWS
  • APPLE
  • MS OFFICE
  • RASPBERRY PI
  • WORDPRESS
  • TECH TIPS
  • LINUX
  • VIRTUALIZATION
  • FORUM
No Result
View All Result
AvoidErrors
No Result
View All Result

Create and Connect to a Microsoft SQL Server Database

Miguel by Miguel
July 12, 2017
in Tech Tips
0
Share on FacebookShare on Reddit
RECOMMENDED: Improve PC performance Migrate to Solid State Drive (SSD)

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.

Previous Post

Configure Shadow Copy of Shared Folder Windows Server 2016

Next Post

How To Install and Configure Chef Server on Ubuntu 16.04

Miguel

Miguel

I started this tech blog back in 2011 as a place to write down processes I took to fix my client systems and network. Now I write some tips and tricks to help others with the tech issues that one might encounter.

Related Posts

How to Remove a Website from Google Chrome ‘Never Saved’ password list
Tech Tips

How to Export Bookmarks and Data from other Browsers to Google Chrome

by Rhousse
August 3, 2022
How To Adjust Flashlight on iPhone 12
Tech Tips

How To Adjust Flashlight on iPhone 12

by Ori Otokpa
July 25, 2022

Subscribe to get weekly tutorials direct to your inbox!

Windows

Fix .net Framework 3.5 Missing on Windows 11

by Rhousse
August 13, 2022
Clean Install Windows 11 Without USB
Windows

How to turn off Delivery Optimization on Windows 11

by Muhammad Imran Habib
August 13, 2022
How to Enable Dark Mode on Windows 11
Windows

How to Prevent Users from Changing Proxy Settings in Windows 11

by Muhammad Imran Habib
August 13, 2022
How to Check Laptop Battery Details in Windows 10
Windows

How to Create a New Custom Power Plan in Windows 11

by Muhammad Imran Habib
August 13, 2022
  • Disclaimer & Privacy Policy
  • FAQ
© 2022 Powered by Cloudways
No Result
View All Result
  • HOME
  • WINDOWS
  • APPLE
  • MS OFFICE
  • RASPBERRY PI
  • WORDPRESS
  • TECH TIPS
  • LINUX
  • VIRTUALIZATION
  • FORUM

© 2022 AvoidErrors Powered by Cloudways | Privacy

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.