You created a Windows EC2 instance with a public IP address and installed SQL Server. When attempting to connect to SQL Server from SQL Server Enterprise Manager on your local computer, the Windows EC2 instance is unable to establish a connection to the server. What is the first thing you should check?

Digital Marketing, LinkedIn Amazon Web Services (AWS) Skill Quiz Answers

You no longer need to be worried if you are taking the LinkedIn Amazon Web Services (AWS) Skill Quiz Exam and are unsure about the proper answer to the question “You created a Windows EC2 instance with a public IP address and installed SQL Server. When attempting to connect to SQL Server from SQL Server Enterprise Manager on your local computer, the Windows EC2 instance is unable to establish a connection to the server. What is the first thing you should check?”. I have provided the right answer to your question below.

You created a Windows EC2 instance with a public IP address and installed SQL Server. When attempting to connect to SQL Server from SQL Server Enterprise Manager on your local computer, the Windows EC2 instance is unable to establish a connection to the server. What is the first thing you should check?

Options

  • Verify that you are connecting to the instance using a user that is not sa.
  • Check the policies within Windows Firewall.
  • Check the routing tables for the VPC.
  • Verify that the assigned security groups allow TCP port 1433 traffic from your current IP address.

The Correct Answer Is:

  • Verify that the assigned security groups allow TCP port 1433 traffic from your current IP address.

Conclusion

I believe I was successful in answering your query “You created a Windows EC2 instance with a public IP address and installed SQL Server. When attempting to connect to SQL Server from SQL Server Enterprise Manager on your local computer, the Windows EC2 instance is unable to establish a connection to the server. What is the first thing you should check?”. I hope you easily pass the certification exam and get the certificate as soon as possible. Have a great time! Good luck!