1 Running Microsoft SQL Server on AWS RDS

Amazon provide the platform which allow user to set up the SQL Server very quickly …. Today, I decided to give it a try and feel it is too easy to be true .

First, you have to have the AWS account being created.

Select the <launch a DB instance>

I choice the SQL Server Standard edition.

The master user is the user we can use to connect to db.

The port number does not seem to be able to change after it is created. So, make sure you choice what you like.

After this page, it will take about 10-20 mins for instance to be created.

Security group

In order to access it from remote, we have to add our client IP address to the security group.

The AWS end point does not support ICMP ping.

Connection AWS MSSQL from Sql server management studio

Find the End Point . The End point in the page shows in the format “End Point: Port Number”

The connection string needs to change “End Point,Port number”

Now, I am in

Interestingly, the master user is not sysadmin, Not sure what if I want to create the database.

Monitoring

Error log

The SQL Server error log can not be access from SSMS, I have to use Amazon console to get it.

 

 

Reference

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html