identity manager, active directory and data limitations

Discussion created by empicard on Sep 21, 2012
Perhaps this is a subject that has been discussed before, but I can't narrow it down.

Can someone give me a rough idea or example of what I'm looking for?

Here's the scenario -
I have ~1000 sales territories.  I want my territory managers to be able to log in, and only view their own territory for some data, and nation wide for other data.
I want to use windows authentication.  Who wants to manage 1,000 usernames and passwords?

SQL server 2008