Thursday, June 27, 2013

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.

image

Select the <launch a DB instance>

image

I choice the SQL Server Standard edition.

image

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

image

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

image

image

image

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

image

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.

image

image

image

image

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”

image

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

image

Now, I am in Smile

image

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

image

Monitoring

image

Error log

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

image

image

image

image

 

 

Reference

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

1 comments:

  1. I get a lot of great information here and this is what I am searching for. Thank you for your sharing. I have bookmark this page for my future reference. Search aws jobs in hyderabad.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates