Unanswered: Authentication with multiple Domain groups
I have a user(u1) who is in 2 domain groups(grp1 and grp2). Each group has login permission and has access to a separate database(db1 and db2). The default database for grp1 is db1 and for grp2 it's db2. When u1 connects to the server without specifying a database, how does SQl server determine which database to use as the default.