Deploy MS SQL to AWS

From MgmtWiki
Jump to: navigation, search

Full Title

Deploying an instance of Microsoft SQL Server with ASP.NET core website to Amazon Web Services

Context

  • Bring up a secure SQL server for use by a web site with a minimum of fuss.
  • At first the challenge is
  • The assumption here is that the design is not fully fleshed out as the User Experience needs to be functional before it can be fully evaluated.
  • Later the problem is to get the performance to be good while the deployment expands to multiple instances.

Problems

  • The largest part of the problem is not getting the SQL server to run, but rather to ensure that it is secure and accessible where required.

Solutions

Debugging

Connecting to SQL seems like a never ending black hole, The following link speaks to this group of problems: https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/

  • Debugging the connection from SSMS on a Windows machine can best be tested with telnt id-addr port-number, where port-number = 1433 for SSMS.
    • If telnet is not enabled on your computer got to control-panel > progams-and-features > windows-features and check the box by telnet.
    • The most common reason for the telent error "Could not open connection to the host, on port 23: Connect failed" is observed to the firewall block telnet.exe.
    • If a telnet connection works, then a network connection was established, and the issue is likely caused by the user authentication to the database, such as user name and password

How can I troubleshoot connectivity to an Amazon RDS instance that uses a public or private subnet of a VPC?

  • This issue can occur when the Publicly Accessible property of the instance is set to No.

References