Access EC2 SQL Server from aws session manager

0

Hello, I have an ec2 where the RDP connection is corrupted i need at least to be able to take a backup from the database hosted on it, the remote access for the MS SQL server is not enabled, i need to enable it to be able to connect from my machine using SSMS. I guess that can be enabled from session manager.

Thanks

Walid
asked 6 months ago804 views
1 Answer
0

Let’s try and figure out how you think rdp is “corrupt” That’s kind of impossible. Perhaps you have been using a public ip and it’s changed. Your security group may be allowing the wrong source IP.

You can if setup RdP using ssm instead of native rdp.

You can most likely enable sql remote access via ssm.

Worse case you can mount the volume and backup the ldf and mdf directly.

profile picture
EXPERT
answered 6 months ago
profile picture
EXPERT
Steve_M
reviewed 6 months ago
  • Thank you for your reply, how can i enable sql remote access via ssm? The Public IP is not changed, also tried the public name with no luck, i have the below error: your remote desktop services session has ended, possibly for one of the following reasons: The administrator has ended the session. An error occurred while establishing the connection. A network problem occurred.

  • Have you tried connecting. Is fleet manager (SSM) rdp?

  • If you have SSM agent installed you’d be able to access the power shell cli remotely. Here you could try to execute sql commands to enable remote sql via tcpip. Don’t forget to open your security group.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions