Sql Server 2008, Active Directory Groups, and Failed Logins
- by Ryan Michela
I keep getting a Login Failed error in my ASP.net application when connecting to my SQL Server 2008 database. I am trying to login with the user domain\foo.
When I grant a database login (server and database level) for domain\foo, my application can connect.
When I put domain\foo in a group called domain/goo and give domain\goo a database login,…