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
posta 6 mesi fa814 visualizzazioni
1 Risposta
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
ESPERTO
con risposta 6 mesi fa
profile picture
ESPERTO
Steve_M
verificato 6 mesi fa
  • 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.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande