But now, how do I consctruct the connection string for my web-application? Do I give it the username and password of one of the members of the group?
And, what do I put for a "user" in the Database security section? The group itself doesn't have a password.
Do I have to add the service account from the application pool to the AD group?
Here is what I have for a connection string; but this allows all connections, it seems:
<add name="development" connectionString="server=myserver\sqlexpress; database=mydatabase;Persist Security Info=True;Integrated Security=SSPI; Trusted_Connection=True; Pooling=True" providerName="System.Data.SqlClient" />