Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
AWS re:Postre:Post

Connecting to SQL Server at LightSail with SSMS

0

Please, I have just created an instance of SQL Server at Lightsail, I have a Static IP though I am not able to connect using SSMS (SQL Server Management Studio) that it´s installed in my notebook. Can anyone help me with it please?

Argomenti
DatabaseComputazionali
Tag
Microsoft SQL ServerAmazon Lightsail
Lingua
English
rePost-User-6737098
posta un anno fa366 visualizzazioni
2 Risposte
0

Hi - Have you checked the Lightsail Instance Firewall and Ports that are allowed? You will likely need to allow traffic inbound to your Lightsail instance on the ports that are required by SSMS. Please also remember that you would need to allow traffic from your specific public IP only so as to protect your instance. Please see: https://lightsail.aws.amazon.com/ls/docs/en_us/articles/understanding-firewall-and-port-mappings-in-amazon-lightsail

profile pictureAWS
Thiru A
con risposta un anno fa
profile picture
ESPERTO
Sedat Salman
verificato un anno fa
  • rePost-User-6737098
    un anno fa

    Thanks Thiru A I have added the standard SQL Server port 1433 rule, but so far I have not achieved to make it work with SSMS. My public IP doesn´t even ping

0

Yes, ping will need ICMP to be opened. Having said that, what about the firewall within Windows itself? Have you checked that?

profile pictureAWS
Thiru A
con risposta un anno fa

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

Contenuto pertinente