i use ms sql 2005 server . guide me: how to Allow remote SQL connections from specific IP.
Follow these steps to configure SQL Server 2005 to allow remote connections:
Source: Microsoft Knowledge Base
Then to allow only specific IPs to access your MS SQL server, create a firewall rule that will allow this specific IP through TCP 1433 and TCP 1434, and block those ports from any other IPs.