how to exclude connections from a computer ?

Question

Post reply

how to exclude connections from a computer ?

awu

SSCrazy

Points: 2037
More actions
November 16, 2011 at 11:44 am

#260055

We need to stop connections from a web server, I just created a job running every minute to kill all connections from that box by "hostname", wondering is there a better way to do it ? thanks.

ddfg

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323482 More actions · Answer 1

stop connections permanently, like using the firewall to ignore all traffic from the webserver?

i'd go firewall first, a login trigger would work for an entirely SQL solution, but the hostname can be faked in a connection string, so that's not 100% bulletproof;

firewall is my first choice.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

okbangas SSChampion Points: 11773 More actions · Answer 2

I completely agree. The one and only way to disable access from a specific server is a fire wall rule denying connections from all IP addresses of the server(s) that you want to deny access. In some cases, it may be possible to circumvent this restrictions by routing traffic, possibly over a VPN connection, but I'd say this would be a rare case.

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]