Prerequisites
AWS - RDS (MS SQL Server)
Create Proof of Concept (Free Tier) Database
Navigate to RDS > Create database
| Choose a database creation method | |
| Standard Create | Choose this option |
| Engine options | |
| Engine Type | Microsoft SQL Server |
| Edition | SQL Server Express Edition |
| Version | Choose latest applicable version |
| Templates | |
| Free tier | Choose this option |
| Settings | |
| DB instance identifier | G53-RDS-POC |
| Credentials Settings - Master username | sa |
| Credentials Settings - Master password | Provide a strong password (without special character) |
| DB instance size | |
| Burstable classes | db.t2.micro |
| Storage | |
| Storage Type | General Purpose (SSD) |
| Allocated storage | 20 GiB |
| Storage autoscaling | Disable |
| Connectivity | |
| VPC | Select Default VPC |
| Subnet group | default |
| Publicly accessible |
Yes - if you are connecting to this database from outside the VPC No - if you are connecting to this database from inside the VPC (EC2 instances) |
| VPC security group | Choose existing or create new security group |
| Availability Zone | No preference |
| Database port | 1433 |
| Microsoft SQL Server Windows Authentication | |
| Enable Microsoft SQL Server Windows authentication | Do not enable option |
| Additional configuration | |
| Database options - DB parameter group | default... |
| Database options - Option group | default... |
| Database options - Time zone | No preference |
| Database options - Collation | blank |
| Backup - Enable automatic backups | Disable |
| Performance Insights - Enable Performance Insights | Disable |
| Monitoring - Enable Enhanced monitoring | Disable |
| Log exports - Select the log types to publish to Amazon CloudWatch Logs | Disable |
| Maintenance - Enable auto minor version upgrade | Disable |
| Maintenance - Maintenance window | No preference |
| Deletion protection - Enable deletion protection - Maintenance window | Disable |
Click 'Create database'
Connect to your Database
Select your endpoint under properties and use your username and password to connect to your database.
