Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
COURSE of the MONTH
7 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Automatically Banning IP Addresses
Posted on 2003-02-24
I have a windows 2000 advanced server running sql server 2000.
I want to know if there is a way in which I can use ado and asp (and perhaps sql stored procedures) to automatically add ip's to the banned ip list in the internet services manager.
Code examples or hints would be a bonus!
Thanks
I want to know if there is a way in which I can use ado and asp (and perhaps sql stored procedures) to automatically add ip's to the banned ip list in the internet services manager.
Code examples or hints would be a bonus!
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Hi!
It would take up too much room to show any code here.
But one very possible approach would be the following.
Make sure you are running the MS SQL Agent Service.
Now with DB connections and ASP.
You can do the following.
I don't know where the banned IPs are stored but if they are in registry you can create a .reg registry file with ASP.
Then use the DB to execute:regedit /s C:\whatever\blah\ban_ip.re
Since DB is usually running as either local system account or an admin user so it has the right to run such a script.
If the banned IPs aren't stored in registry, it would be much harder to do.
I hope I gave you some ideas.
Regards
/Hans - Erik Skyttberg
It would take up too much room to show any code here.
But one very possible approach would be the following.
Make sure you are running the MS SQL Agent Service.
Now with DB connections and ASP.
You can do the following.
I don't know where the banned IPs are stored but if they are in registry you can create a .reg registry file with ASP.
Then use the DB to execute:regedit /s C:\whatever\blah\ban_ip.re
Since DB is usually running as either local system account or an admin user so it has the right to run such a script.
If the banned IPs aren't stored in registry, it would be much harder to do.
I hope I gave you some ideas.
Regards
/Hans - Erik Skyttberg
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key.
We will concen…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
- Web Development
- Ransomware
- Cybersecurity
- Security
- Monitis
- Web Servers
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month7 days, 23 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.