Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Limiting Access by IP

Author  Topic 

brkonthru
Starting Member

31 Posts

Posted - 2004-07-30 : 19:59:09
Is there any way in sql server itself or a security add-on product to limit access to an SQL account by an IP address range ?

Thanks,

Kristen
Test

22859 Posts

Posted - 2004-07-31 : 02:06:41
To the best of my knowledge you need a firewall for this job

Kristen
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-31 : 12:46:45
That's the only way available currently. I don't know of any add-ons for this either. If you find one, let us know. :)

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

kselvia
Aged Yak Warrior

526 Posts

Posted - 2004-07-31 : 17:22:09
How would a firewall limit access to a specific account for an IP range?

--Ken
Your Kung-Fu is not strong. -- 'The Core'
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-01 : 14:59:53
It couldn't to a SQL account if it's using standard security. It could just limit ALL the traffic.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -