I have a SQL server that I host databases for customers on.
The SQL server port is protected by de windows firewall. Right now I manually open up the tcp 1433 port for the external IP addresses/
Would this be something that can be done from the solidcp portal?
Hello,
Thats currently not possible.
Also i would be careful having port 1433 open fully, they tend to get checked by botnets.
If possible i would always limit access with IP restrictions only.
Regards,
Marco
Yeah exactly. Hence the question.
Hello,
Thank you for the suggestion. I have added it to our tracker but currently we do not have any ETA of when/if this will be added.
Kind Regards,
Trevor Robinson
I would reccomend that you dual bind your server to two ports namely 1433, and then some other port like 1435 or something. Then you firewall off the 1433 from the public users and only allow the other port ie 1435. This then requires that your customers create a mssql alias on their machines with the correct servers ip address and the 1435 port.
They then use the alias name to connect to in SSMS. Just takes away the bots from constantly hitting port 1433.
