AWS Windows Workstation Configuration with SQL Server Management Studio

If you are not allowed to install software on your local machine, you can use the Windows workstation that has been deployed to your lab environment.

Before using this guide, follow the assignment instructions under Accessing the AWS Management Console.

Steps:


Locate the IP address

  1. Return to the window you used to start the lab.

  2. At the top of the page, choose the AWS Details dropdown menu.

  3. In the pop-up window, locate WindowsWorkstation.

  4. Save the IP address for the workstation.

    Note: You will use this IP address in the lab when configuing your Security Group Rule.


Connect to the workstation

Depending on your Operating System, you will start one of the following applications:

Operating SystemApplication
WindowsRemote Desktop Connection
ChromeChrome Remote Desktop
MacMicrosoft Remote Desktop

 

  1. Start the remote desktop application.

  2. Use the plus symbol to add a new connection.

    Note: Do not choose the Workspace option.

  3. When prompted, enter the WindowsWorkstation IP address, and choose Add.

  4. Doubleclick on the connection you just created.

  5. When prompted, enter the following values:

    • Username: Administrator
    • Password: Welcome1

  6. Choose Continue.

 

Configure the browser

 

  1. From the task bar at the bottom of the screen, open Internet Explorer (ie).
  2. In the Setup Internet Explorer pop-up window, choose OK.
  3. In the top right corner of the ie window, choose the small gear-shaped icon.
  4. From the drop down menu, select Internet Options.
  5. Select the Security tab.
  6. In the box labeled "Select a zone to view or change security settings", select Trusted Sites .
  7. Choose the Sites button.
  8. In the text box labeled, "Add this website to the zone", enter https://*.microsoft.com.
  9. Choose Add.
  10. In the same text box, enter https://*.azure.com.
  11. Choose Add.
  12. Choose Close
  13. Choose Ok.

Download SQL Server Management Studio

  1. In the ie window, enter the following URL: https://aka.ms/ssmsfullsetup and press enter.

  2. If you are prompted with pop-up windows, choose accept and close the windows.

  3. You will see a warning at the bottom of the browser window similar to - This type of file could harm your computer. Choose Save to download the file.

Install the software

  1. Once you receive the message confirming that the download has completed, choose the Run button.
  2. You will be promted to Click "install" to begin. Choose the Install button.
  3. Once the installation has completed, choose Close.

 

Return to the instructions for the lab assignment.

When you are instructed to perform tasks on your local machine, you can now use the AWS workstation instead.