I need to restrict remote connections to my SQL server in the Windows server, but I need to allow a few specific IPs to be able to connect remotely.
I enabled TCP/IP in SQL Configuration Manager and enabled remote connection and SQL server authentication on my server instance. Now, I have made a new inbound rule for TCP port 1433 and added a few IPs to allow the connection, but with these settings, everyone can access my SQL server remotely not just the IPs I added in the firewall rule.
What should be changed/added to allow to connect remotely only those specific IPs?