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.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容