Connecting and validating EC2SQL2 using the Jumpserver

This second server also resides in a private subnet. Similar to EC2SQL1 the only way to connect to it is via the jumpserver

  1. Within the jump server, you can first validate EC2SQL2 by opening up SSMS and connect to it directly, as it has a running standalone instance of SQL Server that is open for remote connections

  2. You can also verify EC2SQL2 server by connecting to it using an RDP session within the jumpserver:

  3. When asked for a user name and password, use the same credentials used to login the jumpserver:

  4. Once inside EC2SQL2, you can validate the various SQL Services that’s currently running: