We want to give access to regional staff across the country to a database
that only supports Windows Authentication.
The staff should only see data from their own region. So the database needs
to know who exactly the user is, so that it filters out the data accordingly.

We do not have a nationwide Windows network, so we cannot use IIS Windows
Auth.

Assuming we'd be using Forms Auth, how can we pass on the user identity to
this database? In other words, how can we assign each individual user to a
unique Windows account that would uniquely identify the user to the database?

Looks like what I'm looking for, I'll try it out.
Thanks.

[quoted text, click to view]