2

I want to tighten security by forbidding 'sa' logins unless they're from the local subnet. Is there a way to list somewhere the acceptable subnets certain users can connect from in SQL server 2000 or SQL server 2008?

Thanks!

Isaac

IsaacB
  • 335
  • 1
  • 5
  • 12

1 Answers1

2

In SQL 2008, you can use logon triggers. Read all about it here.

Ben Thul
  • 3,024
  • 17
  • 24