DEV Community

Cover image for Creating an Amazon RDS DB Instance (MS SQL Server)
Frank Promise Edah
Frank Promise Edah

Posted on

Creating an Amazon RDS DB Instance (MS SQL Server)

STEP1
Create a relational database.

To create a relational database, go the aws console, search for RDS. Make sure the engine options is set to Mysqlserver. As soon as the DB is up and running, the security group settings can be changed. For instance, the inbound rules can be edited to allow traffic from any where if there isn't any known IP addresses. same with the outbound rules.

STEP2
In order to connect to the local server, copy the endpoint of the RDS. On the local engine, paste the endpoint on the space for 'server name', chose the mysql engine for authentication, enter the username and password generated during the RDS creation stage.

Top comments (0)