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
已提問 6 個月前檢視次數 814 次
1 個回答
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
專家
已回答 6 個月前
profile picture
專家
Steve_M
已審閱 6 個月前
  • 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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南