This is will be first of likely many posts on Amazon Web Services, specifically RDS.
As a Database Administrator needs will arise to perform administrative tasks such as reviewing existing instances, creating new ones, taking a snapshot ( so that we can a fallback in case we mess things up), create and review security groups.
Yes, these tasks can be completed via the Web Console. But, seriously, in some cases nothing beats scripting.
And, so let us see how we can access scripting functions.
Took to the web portal https://console.aws.amazon.com/console/home.
No CLI Interface Menu
There is no interface to the CLI Console.
So how to get a CLI Console ?
Found a nice lead-in “Installing the AWS Command Line Interface” here.
As my current machine is MS Windows, chose the MSI Path.
Installed Downloaded application.
Chose to target D:\Program Files\Amazon\AWSCLI.
Launch Command Session
Launch command session (cmd.exe)
CD /D [installed-folder]
CD /D D:\Program Files\Amazon\AWSCLI\awscli
We need to provide our Access ID and Key.
And, optionally a default region.
D:\Program Files\Amazon\AWSCLI\awscli\> aws configure AWS Access Key ID [None]: AWS Secret Access Key [None]: Default region name [None]: Default output format [None]:
Skipped AWS Configure
If you try to issue commands, before first setting your credentials, you will get the error pasted below.
Unable to locate credentials. You can configure credentials by running &quot;aws configure&quot;.
Describe DB Instance
D:\Program Files\Amazon\AWSCLI\awscli>aws rds describe-db-instances
D:\Program Files\Amazon\AWSCLI\awscli>aws rds describe-db-instances --region us-east-1
A client error (AccessDenied) occurred when calling the DescribeDBInstances operation: User: arn:aws:iam:1i118717:user/daniel is not authorized to perform: rds:DescribeDBInstances
- In our case, our account has yet to be privileged to query for DB Instances
Here is a list of RDS Commands – RDS – References
AWS Command Line Interface
- Getting Help with the AWS Command Line Interface
- Command Structure in the AWS Command Line Interface
Microsoft SQL Server on Amazon RDS
- AWS Documentation » Amazon Relational Database Service (RDS) » User Guide » Microsoft SQL Server on Amazon RDS