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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠