I'm trying to find a solution to use SQL application roles in a web application w/ IIS 5.1 and .NET 1.1.
Since the SQL connections are pooled, I cannot ensure that the next time my logged in user cames in, he'll receive the same connection! Does anyone passed through this and found a suitable solution