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
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