Welcome to ISAserver.org

Control IP address access to SQL Server

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA 2006 Publishing] >> Server Publishing >> Control IP address access to SQL Server

Page: [1]

Message

<< Older Topic Newer Topic >>

Control IP address access to SQL Server - 20.Aug.2006 7:41:59 PM

tderenthal

Posts: 7
Joined: 5.Nov.2002
Status: offline

I have published a SQL server. That works fine. But I only want certain IP addresses out on the internet to have access. This is because of that brute force SQL Server log on attack out there. I only want 1433 access for my developer (ex: 69.xxx.xxx.xxx) and access for replication from another SQL server (ex: 63.xxx.xxx.xxx). Can't figure how to do this. Thanks for any help.

Post #: 1

Featured Links*

RE: Control IP address access to SQL Server - 20.Aug.2006 11:41:47 PM

gja

Posts: 50
Joined: 15.Aug.2006
From: The Netherlands
Status: offline

When you want to do this you have to configure two rules. One rule for 1433 acces from your developers ip and a second rule that allows access for replication from the IP address of the other SQL server. In the publishing rule you can edit the field where the "from" adresses are defined, by default this is "anywhere".

Good luck

(in reply to tderenthal)

Post #: 2