Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

How to build an Enterprise Environment in AWS for SQL Server


By:   |   Read Comments (1)   |   Related Tips: More > Cloud Computing

Quickly Resolve Performance Problems for IIS, .NET and SQL Server       >>>   Get Started


Problem

Many small and large enterprises want to move their SQL Server databases and applications into the cloud using Amazon Web Services. In this tip we look at how you can build an enterprise environment using AWS to get ready to make the move to the cloud.

Solution

This tip will help all technology professionals, DBA Managers and IT Directors to build an enterprise level environment. This tip is intended for anyone who doesn’t want to build or manage an on-premises data center or infrastructure.

How to build Enterprise Environment in AWS

Basic information about Amazon EC2

Amazon Web Services is available and accessible across the world.  AWS has multiple regions and each region has multiple availability zones and each zone consists of one or more discrete data centers, with redundant power capabilities, networking and connectivity all housed in separate facilities.  By default when you configure the services it will assign the nearest region, however you can change the region based on your needs.

Here is an example of how this looks for different regions.

Region has multiple availability zones - Description: AWS has multiple regions and each region has multiple availability zones and each zone consists of one or more discrete data centers, with redundant power capability, networking and connectivity; all housed in separate facilities and by default it will assign nearest region; however if you want to change the region you can change the region. In our case we are in Ohio Region and it allows 3 availability zones.

In our case we are using the US East (Ohio) region which allows for 3 availability zones.

AWS has multiple region. - Description: AWS has multiple region.

Amazon Elastic Compute Cloud (EC2) also referred to as an EC2 instance is a cloud based server. In the cloud based server you can install your own Windows server and SQL Server license or a license offered by Amazon Web Service (AWS). In EC2 you can create a Windows Server Data Center edition (free tier) or you can pay as you go on an hourly basis. To calculate what the hourly charges might be, click here.

You can build up your server with just a few clicks as per your needs – Amazon offers a wide selection for instance types to best fit your requirement – you can compare various types of instance combinations for memory, storage, networking and CPU capacity. For more information visit the Amazon AWS site.

Before we begin to build our first EC2 instance we need to create a virtual private could (VPC) with availability zones (subnets).

Here I will share how to create an EC2 instance with all related requirements on AWS (by default AWS provides the VPC, route table, security group, Internet Gateway, subnets, Network ACLs) when you open a new account.

First you need to create and open an AWS account to configure the EC2 window server with SQL server. To create an account follow the steps in this article by Tim Cullen

OK, let’s start our AWS project – go to your AWS management console to get started.

Step # 1 – Create Virtual Private Cloud (VPC)

A virtual private cloud (VPC) is a virtual network dedicated to your AWS account. You can launch your AWS resources, such as Amazon EC2 instances server into your VPC. By creating a Virtual Private Cloud (VPC) in AWS you will have complete control over your virtual networking environment including selecting your own IP address range, creating subnets, configuration of routing tables, and network gateways.

You can customize the network configuration for your Amazon virtual private cloud; for example create public facing subnets for web servers that have access to the internet and place backend items such as a database or application servers in a private-facing subnet with no internet access.

You can create multiple layers of security including security groups and network access. When you create the VPC you will get option to select the tenancy; if you select the Default Tenancy then the instance will run on shared hardware and if you select Dedicated Tenancy then the instance will run on single tenant hardware. In additional you can create a hardware and software virtual private network (VPN) to connect between your corporate data center and the AWS cloud environment.

Click on Services on the top left side and under Networking and Content delivery select VCP.

Services top left side -> under Networking and Content delivery --> select VCP - Description: Services top left side -> under Networking and Content delivery --> select VCP

On the VPC dashboard page, click on Your VPCs.

VPC dashboard page, click on Your VPCs. - Description: VPC dashboard page, click on Your VPCs.

On the Your VPCs page, click Create VPC.

On “Your VPCs” page click Create VPC.  - Description: On “Your VPCs” page click Create VPC.

In the Create VPC dialog box, put the Name tag, IPv4 CIDR block and Tenancy. For Tenancy select Default or Dedicated. If you select Default then the instance will run on shared hardware and if you select Dedicated then instance will run on single tenant hardware. Now click on Yes, Create.

Create VPC dialog box, put the name tag, IPV4 CIRD Block and Tenancy Select Default or dedicated - Description: Create VPC dialog box, put the name tag, IPV4 CIRD Block and Tenancy Select Default or dedicated – if you select default then the instance will run on shared hardware, and if select dedicated then instance will run on single tenant hardware. Now hit Yes, Create.

Here is a closer look.

the closer look of VPC dialog box - Description: the closer look of VPC dialog box

After creating the VPC, it will appear with the VPC status as available.

it will appear as VPC status as available. - Description: After creating the VPC, it will appear as VPC status as available.

On Your VPCs page, select the VPC to change the DNS hostname and go to Actions and click on Edit DNS Hostnames.

Your VPCs page, select the VPC to change the DNS hostname and go to the Actions and click on Edit DNS Hostnames - Description: On Your VPCs page, select the VPC to change the DNS hostname and go to the Actions and click on Edit DNS Hostnames.

On the Edit DNS Hostnames dialog box select Yes and then Save.

On Edit DNS Hostnames dialog box select Yes and Save it. - Description: On Edit DNS Hostnames dialog box select Yes and Save it.

Step # 2 – Create Subnets

When you create a VPC it spans all availability zones within the region and after creating a VPC you can add one or multiple subnets in one or more availability zones. When you create subnets you specify the CIDR block for the subnet. If you create more than one subnet in a VPC, the CIDR blocks of the subnets cannot overlap. For example, if you create a VPC with CIDR block 10.0.0.0/16, it supports 749 IP addresses and you can break this CIDR block into three subnets, each supporting 250, 250 and 249 IP addresses. You will get an option to select the availability zone or you can leave as no preference and AWS will assign it.

On the Subnet page, click on Create Subnet.

On Subnet page click on Create Subnet. - Description: On Subnet page click on Create Subnet.

On the Create Subnet dialog box, enter a subnet name tag, the VPC will automatically get assigned. If there is more than one VPC then select from the drop down menu. Select the Availability Zone from drop down list, there are multiple availability zones in a region (some region have 3 or more Availability Zones). In Ohio there are 3 availability zones (us-east-2a; us-east-2b, us-east-2c). Put the IPv4 CIDR block and click on Yes, Create.

VPC – will automatically get assigned. If there are more than one VPC then select from drop down menu, Select Availability Zone from drop down list, there are multiple availability zones in region  - Description: subnet name tag, VPC – will automatically get assigned. If there are more than one VPC then select from drop down menu, Select Availability Zone from drop down list, there are multiple availability zones in region (some region have 3 or more than 3 Availability Zones); in Ohio there are 3 AZ (us-east-2a; us-east-2b, us-east-2c) put the IPV4 CIDR block and Yes, Create.

Here is a closer look.

VPC – will automatically get assigned. If there are more than one VPC then select from drop down menu, Select Availability Zone from drop down list, there are multiple availability zones in region  - Description: VPC – will automatically get assigned. If there are more than one VPC then select from drop down menu, Select Availability Zone from drop down list, there are multiple availability zones in region

Create all of the other subnets the same way to create multiple subnets. The other subnets can be placed into the same availability zone or a different availability zone. Here I have created a second subnet in a different availability zone.

Create all other subnets same way to create multiple subnets. - Description: Create all other subnets same way to create multiple subnets. Other subnets can be placed into same availability zone or different availability zone. Here I have created second subnet in different availability zone.

Here is a closer look.

Create all other subnets same way to create multiple subnets. - Description: Create all other subnets same way to create multiple subnets. Other subnets can be placed into same availability zone or different availability zone. Here I have created second subnet in different availability zone.

On the Subnet page, the newly created subnet will appear and the status shown as available. Here I have created three subnets, one in us-east-2a, one in us-east-2b and the third in the us-east-2c zone.

On Subnet page newly created subnet will appear and status shown as available  - Description: On Subnet page newly created subnet will appear and status shown as available and also show availability zone along with all other information; here I have created two subnets (availability zone), one in us-east-2a and another in us-east-2b zone and us-east-2c zone.

On the Subnet page, select subnet and go to the Subnet Actions and click on Modify auto-assign IP settings, to modify the auto-assign IP settings.

On Subnet page, select subnet and go to the Subnet Actions and click on modify auto-assign IP Setting, to modify auto-assign IP setting. - Description: On Subnet page, select subnet and go to the Subnet Actions and click on modify auto-assign IP Setting, to modify auto-assign IP setting.

On the Modify auto-assign IP settings dialog box, check Auto-assign IPs and click on Save.

On Modify auto-assign IP setting dialog box, check auto-assign IPs and click on Save. - Description: On Modify auto-assign IP setting dialog box, check auto-assign IPs and click on Save.

Here is a closer look.

On Modify auto-assign IP setting dialog box, check auto-assign IPs and click on Save. - Description: On Modify auto-assign IP setting dialog box, check auto-assign IPs and click on Save.

A success message will appear once the Modify auto-assign IP Settings is done.

Success message will appear once the Modify auto-assign IP Setting is done.  - Description: Success message will appear once the Modify auto-assign IP Setting is done.

Modify the other subnets auto-assign IP setting the same way if there are multiple subnets.

Modify all other subnets auto-assign IP setting same way if there are multiple Subnets. - Description: Modify all other subnets auto-assign IP setting same way if there are multiple Subnets.

Configuration changes will appear as shown below.

Configuration changes will appear as shown below. - Description: Configuration changes will appear as shown below.

Step # 3 – Create Internet Gateway

To connect/communicate via the internet with your AWS VPC cloud environment you need to create an Internet Gateway. An Internet gateway allows communication between the VPC and Internet. After creating the Internet Gateway you need to attach it with the VPC to allow communication between the Internet and VPC.

On Internet gateway page, click on Create Internet Gateway.

On Internet gateway page, click on Create Internet Gateway. - Description: On Internet gateway page, click on Create Internet Gateway.

On the Create Internet Gateway dialog box, put the Name tag and click on Yes, Create.

On Create Internet Gateway dialog box, put the name tag and click on Yes, Create.  - Description: On Create Internet Gateway dialog box, put the name tag and click on Yes, Create.

Here is a closer look.

On Create Internet Gateway dialog box, put the name tag and click on Yes, Create.  - Description: On Create Internet Gateway dialog box, put the name tag and click on Yes, Create.

On the Internet Gateway page, select the newly created Internet Gateway and click on Attach to VPC.

On Internet Gateway page, select the newly created Internet gateway and click on Attach with VPC. - Description: On Internet Gateway page, select the newly created Internet gateway and click on Attach with VPC.

On Attach to VPC dialog box, select the VPC and click on Yes, Attach.

On Attach to VPC Dialog Box, select the VPC and click on Yes, Attach.  - Description: On Attach to VPC Dialog Box, select the VPC and click on Yes, Attach.

On the Internet Gateway page, the status will appear as attached.

On Internet Gateway page, status will appear as attached. - Description: On Internet Gateway page, status will appear as attached.

Step # 4 – Create Route Table

A route table contains all the rules and routes to determine where network traffic is directed. By default, your VPC comes with a route table and if you want you can modify it or create a new custom route table. Each subnet must have a route table, which controls the routing for the subnet. If you do not associate the subnet with a route table then the subnet implicitly associates it with the main route table. You can change the main route table with a custom route table, but you cannot delete the main route table.

On the Route Tables page, click on Create Route Table.

On Route Table page, click on Create Route Table. - Description: On Route Table page, click on Create Route Table.

On the Create Route Table dialog box, provide the route table name and select the VPC and hit Yes, Create.

On Create Route Table dialog box, provide route table name and select VPC and hit Yes, Create - Description: On Create Route Table dialog box, provide route table name and select VPC and hit Yes, Create

Here is a closer look.

On Create Route Table dialog box, provide route table name and select VPC and hit Yes, Create.  - Description: On Create Route Table dialog box, provide route table name and select VPC and hit Yes, Create.

On the Route Tables page, select the newly created Route Table and click on Set As Main Table.

On Route Table page select newly created Route Table and click on Set as Main Table. - Description: On Route Table page select newly created Route Table and click on Set as Main Table.

On the Set Main Route Table dialog box, click Yes, Set.

On Set Main Route Table dialog box click Yes, Set. - Description: On Set Main Route Table dialog box click Yes, Set.

On the Route Tables page, after setting up the newly created Route Table as the main table, go to the Routes tab and click Edit.

On Route Table page, after setting up newly created Route Table as Main Table, go to the Routes Tab and click Edit. - Description: On Route Table page, after setting up newly created Route Table as Main Table, go to the Routes Tab and click Edit.

On the Route Tables page, on the Routes tab click on Add another route and add the Destination IPs and select the target as the Internet Gateway and then click Save.

On Route Table page, routes tab click on add another gateway, and add Destination IPs and select target as Internet Gateway and save. - Description: On Route Table page, routes tab click on add another gateway, and add Destination IPs and select target as Internet Gateway and save.

On the Route Tables page, the changes will appear as shown below.

On Route Table page, changes will appear as shown below. - Description: On Route Table page, changes will appear as shown below.

Step # 5 – Create Network ACLs

A network access control (ACL) is an optional layer of security for your VPC and acts as an additional firewall on the security group for controlling the traffic for the subnets. You might set up network ACL rules similar to your security groups in order to add an additional layer of security to your VPC. By default, the VPC comes with a default network ACL, and by default it allows all inbound and outbound IPv4 traffic. You can create a custom network ACL and associate it with a subnet. By default, each custom network ACL denies all inbound and outbound traffic until you add rules.

On Network ACLs page, click on Create Network ACL.

On Network ACLs page, click on Create Network ACL - Description: On Network ACLs page, click on Create Network ACL

On Create Network ACL page, enter the Name tag and select the VPC and hit Yes, Create.

On Create Network ACLs page, click on dialog box give the Name Tag and select VPC and hit Yes, Create - Description: On Create Network ACLs page, click on dialog box give the Name Tag and select VPC and hit Yes, Create

On Network ACLs page, select the newly created network ACL and go to the Inbound Rules tab and click on Edit.

On the Inbound Rules tab click on Add another rule and enter a Rule # and Type (select the port number to open the appropriate port), give source IPs and then click Save.

On Network ACLs Page, select newly created network ACL and go to Inbound Rules tab and click on Edit. - Description: On Network ACLs Page, select newly created network ACL and go to Inbound Rules tab and click on Edit.

On Network ACLs page, select the newly created network ACL and go to the Outbound Rules tab and click on Edit.

On Network ACLs page, select newly created network ACL and go to Outbound Rules tab and click on Edit.  - Description: On Network ACLs page, select newly created network ACL and go to Outbound Rules tab and click on Edit.

On the Outbound Rules tab click on Add another rule and enter a Rule # and Type (select the port number to open the appropriate port), give source IPs and then click Save.

On outbound rules tab click on add another rule and give rule # and then select the port # (open appropriate port) in type give source IPs and save it. - Description: On outbound rules tab click on add another rule and give rule # and then select the port # (open appropriate port) in type give source IPs and save it.

Step # 6 – Change Network ACLs in Subnets

After creating a custom network ACL, if you want to change the subnet to use custom network ACL do the following.

On the Subnets page, select the subnet and go to the Network ACL tab and click on Edit.

On Subnets page, select subnet and go to the Network ACL tab and click on Edit. - Description: On Subnets page, select subnet and go to the Network ACL tab and click on Edit.

On the Network ACL tab, change the current network ACL to the newly created Network ACLs and click Save.

On Network ACL tab page change the current network ACL as newly created Network ACLs and save it. - Description: On Network ACL tab page change the current network ACL as newly created Network ACLs and save it.

After successfully changing the network ACLs it will appear as shown below.

On successfully changing network ACLs it will appear as shown below. - Description: On successfully changing network ACLs it will appear as shown below.

Step # 7 – Create Security Group

A security group acts as a virtual firewall to control all traffic for one or more EC2 instance servers to secure the environment. When you launch new instance server you need to specify the security group and within the assigned security groups the server instances will communicate each other. You can modify the rules for the security group and the new rules automatically applied to all instance servers that are associated with the security group.

On the Security Group page, click on Create Security Group.

On Security Group page, click on create Security Group. - Description: On Security Group page, click on create Security Group.

On the Create Security Group dialog box, enter a Name Tag and select the VPC and hit Yes, Create.

On Create Security group dialog box, give the Name Tag and select VPC and hit Yes, Create - Description: On Create Security group dialog box, give the Name Tag and select VPC and hit Yes, Create

On the EC2 Dashboard page, go to the Security Groups and select the newly created security group. Then go to the Inbound tab and click on Edit.

On EC2 Dashboard page, go to the Security Groups and select newly created security group, then go to the Inbound Tab and click on Edit. - Description: On EC2 Dashboard page, go to the Security Groups and select newly created security group, then go to the Inbound Tab and click on Edit.

On the Edit Inbound Rules dialog box, select the type (open appropriate port) and enter the security group id (this will allow your EC2 instances to communicate with each other within the security group assigned.  Click on Add Rule to add an extra row type (open appropriate) select RDP and in Source select My IP (to open secure RDP connection for your EC2 instance server) then click Save.

On Edit Inbound Rules dialog box, select type (open appropriate port) and put the security group id (this will allow your EC2 instance to communicate each other within security group assigned.  Click on Add rule to add extra row type (open appropriate) select RDP and in source select my IP (to open secure RDP connection for your EC2 instance server) then click save. - Description: On Edit Inbound Rules dialog box, select type (open appropriate port) and put the security group id (this will allow your EC2 instance to communicate each other within security group assigned.  Click on Add rule to add extra row type (open appropriate) select RDP and in source select my IP (to open secure RDP connection for your EC2 instance server) then click save.

After successfully changing the Inbound Rules it will appear as shown below.

On successfully changing Inbound Rules it will appear as shown below. - Description: On successfully changing Inbound Rules it will appear as shown below.

After successfully changing the Outbound Rules it will appear as shown below.

On successfully changing Outbound Rules it will appear as shown below. - Description: On successfully changing Outbound Rules it will appear as shown below.

We have created all of the prerequisites, now we can create EC2 instances.

Step # 8 – Create EC2 Instance in AWS Management Console

Amazon Elastic Compute Cloud (EC2) also called EC2 instance is a cloud based server. In a cloud based server you can install your own Windows server/ SQL Server with MSDN license or you can use a license offered by Amazon Web Service (AWS). In EC2 you can create Windows Server Data Center edition (free tier) or you can pay as you go on an hourly basis. To calculate your hourly charges click here.

You can build up your server with few clicks as per your requirement. Amazon offers a wide selection for instance types to best fit your needs. You can compare various types of instance combinations of memory, storage, networking and CPU capacity. For more info you can visit the Amazon AWS site click here.

To create an EC2 Instance click on Services (top left side) and under the Compute select EC2.

To create EC2 Instance click on Services (top left side) and under the Compute select EC2. - Description: To create EC2 Instance click on Services (top left side) and under the Compute select EC2.

On the Resource Group dialog box, click on Launch Instance.

On Resource Group dialog box, click on Lunch Instance. - Description: On Resource Group dialog box, click on Lunch Instance.

Select the appropriate Amazon Machine Image (AMI) as shown below.

Select appropriate Amazon Machine Image (AMI) as shown below. - Description: Select appropriate Amazon Machine Image (AMI) as shown below.

On the Choose an Instance Type page, select the instance type and hit Next: Configure Instance Details. (For more information click here.)

On Choose an Instance Type page, select instance type and hit Configure Instance Details - Description: On Choose an Instance Type page, select instance type and hit Configure Instance Details

On the Configure Instance Details page, enter the number of instances needed to be created then select the network VPCs, Subnet, and click on Next: Add Storage.

On Configure Instance Details page, enter number of instances need to be created then; select network VPCs, select subnet, and click on Add Storage.On Configure Instance Details page, enter number of instances need to be created then; select network VPCs, select subnet, and click on Add Storage. - Description: On Configure Instance Details page, enter number of instances need to be created then; select network VPCs, select subnet, and click on Add Storage.

On the Configure Instance Details page, Tenancy selection is very important. When you select Run a shared hardware instance and if you are planning to use your own SQL Server license then you need to a mobility agreement from Microsoft, so there won’t be a licensing conflict. When you select Run a Dedicated instance then you do not need a licenses agreement, but the EC2 instance price will be a little more.

configure instance details

On the Add Storage page, click on Add New Volume (In free tier there will be 30 GBs storage available) and select the Volume Type and click Next: Add Tags.

On Add Storage page, click on Add new Volume (In free tier there will be 30 GBs storage available) and select volume type and click Add Tags. - Description: On Add Storage page, click on Add new Volume (In free tier there will be 30 GBs storage available) and select volume type and click Add Tags.
On Add Storage page, click on Add new Volume (In free tier there will be 30 GBs storage available) and select volume type and click Add Tags. - Description: On Add Storage page, click on Add new Volume (In free tier there will be 30 GBs storage available) and select volume type and click Add Tags.

On the Add Tags page, click on Add Tag.

On Add Tag page, – click on Add Tag.  - Description: On Add Tag page, – click on Add Tag.

On the Add Tags dialog box, give Key name and Value as the Server Name and then click on Next: Configure Security Group.

On Add Tags dialog box, give Key Name and Value as Server Name and then click on Configure Security Group. - Description: On Add Tags dialog box, give Key Name and Value as Server Name and then click on Configure Security Group.

On the Configure Security Group page, select an existing security group and then click on Review and Launch.

On Configure Security Group page, select an existing security group and then select security group and click on Review and Launch. - Description: On Configure Security Group page, select an existing security group and then select security group and click on Review and Launch.

On the Review Instance Launch page, review all of the configuration settings and hit Launch.

On Review Instance launch page, review all configuration setting and hit launch. - Description: On Review Instance launch page, review all configuration setting and hit launch.

On the Select an existing key pair or create a new key pair dialog box click on Create a new key pair (or select an existing key pair) and enter a Key pair name and click on Download Key Pair. (Save the key pair in a secure location). Then click Launch Instances.

On Select an existing key pair or create a new key pair dialog box  click on create new key pair or select an existing key pair and give key pair name and click on download to download key pair. (Save the key pair in secured location). Hit Launch Instance. - Description: On Select an existing key pair or create a new key pair dialog box  click on create new key pair or select an existing key pair and give key pair name and click on download to download key pair. (Save the key pair in secured location). Hit Launch Instance.
On Select an existing key pair or create a new key pair dialog box  click on create new key pair or select an existing key pair and give key pair name and click on download to download key pair. (Save the key pair in secured location). Hit Launch Instance. - Description: On Select an existing key pair or create a new key pair dialog box  click on create new key pair or select an existing key pair and give key pair name and click on download to download key pair. (Save the key pair in secured location). Hit Launch Instance.

On the Launch Status page, an instance launching message will appear as shown below.

On Launch Status page, Instance launching message will appear as shown below. - Description: On Launch Status page, Instance launching message will appear as shown below.

On the Instances page, we will see the Instance State as running and Status Checks as initializing.

On Instance page, we will see message appearing as Instance running state and status is initializing. - Description: On Instance page, we will see message appearing as Instance running state and status is initializing.

After complete, on the Instances page the instance Status Checks will show as passed and the AWS instance is up and running.

On Instances page, the Instance is initialized the status will be shown as passed and AWS Instance is up and running. - Description: On Instances page, the Instance is initialized the status will be shown as passed and AWS Instance is up and running.

On the Instances page, click on Connect.

On Instances page, click on Connect. - Description: On Instances page, click on Connect.

On the Connect To Your Instance dialog box, click on Get Password.

On Connect To your Instance dialog box, click on Get Password. - Description: On Connect To your Instance dialog box, click on Get Password.

On the Connect To Your Instance > Get Password dialog box, choose the key pair file (we earlier downloaded the key pair and saved it in a secure location) and Hit Decrypt Password to get the password.

On Connect To your Instance > Get Password dialog box, browse then find the file key pair (earlier downloaded key pair saved on some secured location) and Hit Decrypt Password to get password. - Description: On Connect To your Instance > Get Password dialog box, browse then find the file key pair (earlier downloaded key pair saved on some secured location) and Hit Decrypt Password to get password.

On the Connect To Your Instance dialog box, copy the password and click on Download Remote Desktop File.

On Connect To Your Instance dialog box, copy the password and click on Download Remote Desktop file. - Description: On Connect To Your Instance dialog box, copy the password and click on Download Remote Desktop file.

Double click on downloaded Remote Desktop File and add the credentials and hit Connect.

Double click on Downloaded Remote Desktop File and add the credential and hit Connect.  - Description: Double click on Downloaded Remote Desktop File and add the credential and hit Connect.
Double click on Downloaded Remote Desktop File and add the credential and hit Connect.  - Description: Double click on Downloaded Remote Desktop File and add the credential and hit Connect.

Finally the Amazon Web Services Server Instance connects using RDP.

Finally, Amazon Web Services Server Instance connects thru RDP. - Description: Finally, Amazon Web Services Server Instance connects thru RDP.

Here is a closer look.

Finally, Amazon Web Services Server Instance connects thru RDP. - Description: Finally, Amazon Web Services Server Instance connects thru RDP.
Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Pinakin Patel Pinakin Patel is a SQL Server Admin / AWS Solutions Architect with experience in SQL Server 2000 to 2016.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Friday, September 08, 2017 - 1:45:34 PM - Hassan Back To Top

 Greate work and explaination.

Thanks 

 


Learn more about SQL Server tools