White list

How do I whitelist an IP address coming into my server?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CESNetwork AdministratorCommented:
Please provide more detail.  Depending on the application and setup, this could be done at several places
gmansterAuthor Commented:
The program being accessed is AMSI run on SQL Server
gmansterAuthor Commented:
Any ideas on this?
SD-WAN: Making It Work for You

As bandwidth requirements and Internet costs grow, businesses naturally want to manage budgets by reducing reliance on their most expensive connection types. Learn more about how to make SD-WAN work for your business in our on-demand webinar!

Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
I assume AMSI = "Antimalware Scan Interface" from Microsoft.  White listing usually refers to allowing email to be delivered without running the mail thru various checks and algorithms, which could cause mail to be discarded or filed in a junk/trash location.  

I don't expect AMSI on SQL Server to be receiving email.  I'm either mis-interpretting white list or AMSI, or am unfamiliar with what you are attempting to do in AMSI?

The short answer on "How do I whitelist an IP address coming into my server?": add the IP address to the software's whitelist, or write the software filters to not apply to the specified IP address.
gmansterAuthor Commented:
AMSI is a property management software running on SQL server - We are trying to interface a software called Rent Payment that takes payment on the net.  Rent Payment is getting an error of access when trying to query on our outside IP address to the SQL server.  AMSI says we need to shite list Rent Payments incoming IP address in order for the error to go away however AMSI can't provide me with the information of where in the server to do the white listing.
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Ah.  I assume Rent Payment is attempting to make a direct connection to your SQL Server on port tcp/1433 (unless you've moved SQL to another port, and assuming SQL is configured to use TCP/IP.)  You have a few things to consider/possible places to white list the address:
(a) If your SQL server is using a private IP address, and is using NAT (Network Address Translation) to access the outside, you'll need to configure a Destination NAT, so that the device (usually a router or firewall) that is performing the address translation.  On that router/firewall device, you'll usually have an access control list... this is your equivalent to a white list, to permit traffic in.
(b) If you have internal network security (east-west firewalls), or interior routers with ACLs defined, you'll need to configure those 'whitelists' on each of the routers providing security.
(c) If you have a host based firewall configured on the server hosting SQL Server, you'll need to 'whitelist' the Rent Payment IP address there as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gmansterAuthor Commented:
Let me check on this - Thanks!!!!
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
General information on White Listing provided, as well as where to likely collect more information for a specific instance.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.