By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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?

Topics
DatabaseCompute
Tags
Microsoft SQL ServerAmazon Lightsail
Language
English
rePost-User-6737098
asked a year ago353 views
2 Answers
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
answered a year ago
profile picture
EXPERT
Sedat Salman
reviewed a year ago
  • rePost-User-6737098
    a year ago

    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
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content